Lookup or VLookup or something else??

[GeorgeA]

Hello, I'm trying to solve a problem and was advised to use Lookup but it's
not working. I have 2 worksheets (over 1000 records each). Each worksheet has
a column for email address. I want to reference the email address in
Worksheet 1 (column G) and then search for a match in Worksheet 2 (column F).
When the match is found I want to copy data from column A in Worksheet 2 to
column B in Worksheet 1.
This is the formula I have placed in column B of Worksheet 2:
=LOOKUP($G2,Worksheet1!$F$2:$F$1159,Worksheet1!$A$2:$A$1159)

The step through calculator finds the email address in G2 but fails the next
step. It returns #N/A.

I also tried to use VLOOKUP without luck.
=VLOOKUP($G2,Worksheet1!$F$2:$F$1159,Worksheet1!$A$1:$A$1159,FALSE)
This returns #REF.

I'm under the gun and hope someone can help!

Thanks!

 

[Eduardo]

Hi,
In B2 enter
=sumproduct(--(G2=Worksheet2!$F$2:$F$1159),Worksheet2!$A$1:$A$1159)

Check the name of your tab if it's worksheet2 or sheet2

 

[GeorgeA]

Awesome! Thanks!

Hi,

=INDEX(Worksheet1!$A$2:$A$1159,MATCH($G2,Worksheet1!$F$2:$F$1159,0))


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire