S
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 rang
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 functio
because of repitition of bolded reference.
how can i acheive my purpose.
thanks in anticipation of quick response
formula in cell Sheet1!H4 is, if value in Sheet1!B4 is in a rang
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 functio
because of repitition of bolded reference.
how can i acheive my purpose.
thanks in anticipation of quick response