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