Formula in B6 is
=LOOKUP(D5,{0,5,10,15,20,25,30,35,40,45,50,55,60,6 5,70,75,80,85,90,95,100},{"1","1.5","2","2.5","3", "3.5","4","4.5","5","5.5","6","6.5","7","7.5","8", "8.5","9","9.5","10","10.5","11"})
therefore this gives me a result of 6, as D5 returns figure of 50.

Then Vlookup formula is =VLOOKUP(B6,SHEET1!A34:D54,2). When I input 6
instead of B6 the formula works.

Any help would be much appreciated

"Arvi Laanemets" wrote:

Hi

The formula in B6 returns the value of which type? Maybe you post here the
formula from cell B6, the value displayed in B6, and your VLOOKUP formula.


Arvi Laanemets


"Beginner" wrote in message
...
Hi

Can anyone tell me how you can ref a cell in a vlookup formula for the
lookup_value? I keep getting a #N/A error if I put say B6 but when I
input
the actual number that my ref cell B6 holds, say 6, it works.

Thanks