ExcelBanter - IF & Vlookup

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF & Vlookup (https://www.excelbanter.com/excel-discussion-misc-queries/78835-if-vlookup.html)

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