IF & Vlookup

[starguy]

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.

[Trevor Shuttleworth]

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

Regards

Trevor


"starguy" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>