Use
=IF(ISNA(VLOOKUP(A1,Sheet2!A:B,2,FALSE)),"",VLOOKU P(A1,Sheet2!A:B,2,FALSE))

It will look for A1 anywhere in Col A [Sheet2] and (if found) return the
value from Col B [Sheet2]

If no match is found then ISNA will be true and "" will be returned as the
formula result.
"Ian" wrote:

HI some one was kind enough to show me how this function works, being a
beginner I was wondering if someone could help me figure this out...


Ok this is the function I would like to use:
=IF(ISNA(VLOOKUP(A1,Sheet2!$A$1:$B$500,2,FALSE))," ",VLOOKUP(A1,Sheet2!$A$1:$B$500,2,FALSE))

I just need the parameters to search more then 500 cells i would need more
in the 5000+ cell range

Thanks
Ian