Need a formula to compare email addresses

[dk4210]

Hello Guys

I am trying to figure out how to Compare email addresses from sheet1 (C) and sheet2 (B) and then display the location(A) from sheet 2 in a column(D) of Sheet 1 if the email addresses match

Sheet 1

(A)First name | (B) Last Name | (C) Email address | (D) Location



Sheet 2

(A) Location | (B) Email address

I tried the following formula but doesn't work

=VLOOKUP(C2,Sheet2!A2:B3780,4,FALSE)

Please help

Thanks, Dan

[dk4210]

Some one help a brotha out?

[RobertMika]

Could you post examples/workbook?

[FDibbins]

I think you had your references a bit mixed around? Based on your sample data...
=VLOOKUP(B2,Sheet1!$C$1:$D$6,2,0)

in the formula you used,,,
=VLOOKUP(C2,Sheet2!A2:B3780,4,FALSE)
This is probably on sheet2, so...
...you are trying to search for the value in C2 (sheet2), which contains no data
...your range is column A to column B (ignoring rows for now), based on your sample data, they contain 1st and last names
...you are looking in the 4th column of youe range( ,4, ), but your range only contains 2 columns

[dk4210]

Cant get that formula to work. I get #N/A

[dk4210]

upload a workbook without the info. There are over 3k rows in the real one

[dk4210]

Actually I want to compare the email address from sheet 1 (All of row C) against sheet 2 (All OF row B) IF they match then paste the location on sheet 1 row D from row A Sheet 2

[dk4210]

Some one any one?

[FDibbins]

1st, please have a little patience, all members here offer their help for free, and constant "bumping" will not get you answers any quicker


Try this instead, I mis-read your request, thinking you wanted the location pulled into sheet2...
=INDEX(Sheet2!$A$2:$A$3,MATCH(Sheet1!C2,Sheet2!$B$2:$B$3,0))

[dk4210]

Hey thanks again for the help.
I still get N/A when I run it. Any other ideas?