software

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 quot;Presentquot; otherwise return quot;Notquot;
=IF(*B4*=(VLOOKUP(*B4*,June06,1,0), quot;Presentquot;,quot;Noquot;)
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: www.excelforum.com/member.php...oamp;userid=32434
View this thread: www.excelforum.com/showthread...hreadid=525121=IF(ISNA(VLOOKUP(B4,June06,1,0)), quot;Not Presentquot;,quot;Presentquot;)

Regards

Trevorquot;starguyquot; gt; wrote in
message ...
gt;
gt; i want to find a cell value in range of value i-e:
gt; formula in cell Sheet1!H4 is, if value in Sheet1!B4 is in a range
gt; Sheet2!B5:B700 then return quot;Presentquot; otherwise return quot;Notquot;
gt; =IF(*B4*=(VLOOKUP(*B4*,June06,1,0), quot;Presentquot;,quot;Noquot;)
gt; but this returns N/A. i can understand that this is wrong function
gt; because of repitition of bolded reference.
gt; how can i acheive my purpose.
gt; thanks in anticipation of quick response.
gt;
gt;
gt; --
gt; starguy
gt; ------------------------------------------------------------------------
gt; starguy's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32434
gt; View this thread: www.excelforum.com/showthread...hreadid=525121
gt;