Help in Vlookup and IF Function

[Carizzacris]

Hi All
I am trying to use vlookup and IF function to get a formula that will make the following argument possible:

If the value in Sheet 1 Column G is present in "Sheet 2 column 1", the value should be 'COV" otherwise "Uncov".

i used the following formula but its not 100% working:

=IF(ISNA(VLOOKUP(A10,Sheet2!$1:$1048576,1,FALSE)),"Uncov",)

HELP PLEASE. I attached the file

 

[ptrively]

=IF(ISNA(VLOOKUP(G1,Sheet2!A:A,1,FALSE)),"Uncov","Cov")

Should do it.

(Edit: Didn't notice you said column 1, sheet two, sorry!)

 

[Carizzacris]

That worked. thanks!