View Single Post
  #1   Report Post  
Wazza
 
Posts: n/a
Default 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