Help with IF calculation
 

:)

I created a table from b64 to c82 with the numbers 3-21 scrolling down,
and the values that correspond to these crom c64 down. Then I put that
into the formula of =IF(J12<3,"",VLOOKUP(J12,$B$64:$C$82,2)) , J12 is
currently equalling 3 but the cell is still coming up with #N/A.

Thanks


--
Wazza
------------------------------------------------------------------------
Wazza's Profile: http://www.excelforum.com/member.php...o&userid=16225
View this thread: http://www.excelforum.com/showthread...hreadid=278202

Hi

looks right, okay, let's see what the format is of the cell with 3 in it,
right mouse click on J12, choose format cells - is "text" selected. If so,
click on the OK button, then click on an unused cell somewhere (maybe even
on another sheet) & copy it, click on J12 again and choose edit / paste
special - ADD and click OK.

See if this solves the problem. If not, if you want to remove anything
sensitive from the workbook and email direct to me, i'll take a look
(julied_ng at hcts dot net dot au).

Cheers
JulieD

"Wazza" wrote in message
...

:)

I created a table from b64 to c82 with the numbers 3-21 scrolling down,
and the values that correspond to these crom c64 down. Then I put that
into the formula of =IF(J12<3,"",VLOOKUP(J12,$B$64:$C$82,2)) , J12 is
currently equalling 3 but the cell is still coming up with #N/A.

Thanks


--
Wazza
------------------------------------------------------------------------
Wazza's Profile:
http://www.excelforum.com/member.php...o&userid=16225
View this thread: http://www.excelforum.com/showthread...hreadid=278202