i want to find a cell value in range of value i-e:
formula in cell Sheet1!H4 is, if value in Sheet1!B4 is in a range
Sheet2!B5:B700 then return "Present" otherwise return "Not"
=IF(*B4*=(VLOOKUP(*B4*,June06,1,0), "Present","No")
but this returns N/A. i can understand that this is wrong function
because of repitition of bolded reference.
how can i acheive my purpose.
thanks in anticipation of quick response.


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=525121

=IF(ISNA(VLOOKUP(B4,June06,1,0)), "Not Present","Present")

Regards

Trevor


"starguy" wrote in
message ...

i want to find a cell value in range of value i-e:
formula in cell Sheet1!H4 is, if value in Sheet1!B4 is in a range
Sheet2!B5:B700 then return "Present" otherwise return "Not"
=IF(*B4*=(VLOOKUP(*B4*,June06,1,0), "Present","No")
but this returns N/A. i can understand that this is wrong function
because of repitition of bolded reference.
how can i acheive my purpose.
thanks in anticipation of quick response.


--
starguy
------------------------------------------------------------------------
starguy's Profile:
http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=525121