H
Haz
Hi,
I require a vlookup but can't get this to work for my example below.
In sheet 1 cell C5 I would like to enter a figure which will then do
SUM(80/100*c5) in C7
Based on the % given i would then like to get data from sheet 2 col H and
place in C18 on sheet 1.
Sheet 2 is arranged as follows: Col C is percentage going up in 5, and Col D
is the figure entered in sheet 1 C5 that will determine the % line to read
for Col H. The deviation is 5 percentage between each line.
c d e f g h
5 4 0.0
10 8 0.0
15 12 1.3
20 16 2.7
25 20 4.0
30 25 5.3
35 30 6.7
So if C5 sheet 1 is 16 it will read 2.7 in col H for c18 sheet 1. However if
18 it still needs to read 2.7 in col H until above 20 when it'll be 4.0.
I hope this is clear, but really can't link the two sheets to do this. Any
help would be much appreciated.
Haz
I require a vlookup but can't get this to work for my example below.
In sheet 1 cell C5 I would like to enter a figure which will then do
SUM(80/100*c5) in C7
Based on the % given i would then like to get data from sheet 2 col H and
place in C18 on sheet 1.
Sheet 2 is arranged as follows: Col C is percentage going up in 5, and Col D
is the figure entered in sheet 1 C5 that will determine the % line to read
for Col H. The deviation is 5 percentage between each line.
c d e f g h
5 4 0.0
10 8 0.0
15 12 1.3
20 16 2.7
25 20 4.0
30 25 5.3
35 30 6.7
So if C5 sheet 1 is 16 it will read 2.7 in col H for c18 sheet 1. However if
18 it still needs to read 2.7 in col H until above 20 when it'll be 4.0.
I hope this is clear, but really can't link the two sheets to do this. Any
help would be much appreciated.
Haz