# Lookup or VLookup or something else??

G

#### 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!

E

#### 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

G

#### GeorgeA

Awesome! Thanks!

Shane Devenshire said:
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