Hi,
see if this helps.
If I understand your data...
cell a44 should have a 6 and cell b44 should have a 50
If your vlookup is in cell b6 you need a 6 in d5 then...
=vlookup(d5,a34:b54,2,false) will return a 50 in cell b6

peter
-----Original Message-----
Formula in B6 is
=LOOKUP(D5,
{0,5,10,15,20,25,30,35,40,45,50,55,60,65,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
news:4C2E7DD0-82F0-4B8A-9C82-
...
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



.