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.