Hi

The formula in B6 returns "6", not 6. Probably in range Sheet1!A34:D54 are
numbers, i.e. somewhere there is a number 6
6=6, but 6<"6"

Possible actions:
1. In B6, use the formula

=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})

2. Replace your VLOOKUP formula with
=VLOOKUP("" & B6,SHEET1!A34:D54,2)


--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"Beginner" wrote in message
...
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