Vlookup formula in two sheets

Asked May 11 '20 at 19:55

Active May 11 '20 at 19:55

Viewed 56 times

I have 2 files and I need to do Vlookup

First sheet where I have status of email if it was opened or no and email-address

In second sheet I have just addresses and I need to make vlookup on that emails in second sheet and add there that status from first sheet.

And here is formula I used. But when I press enter it shows error "There's a problem with this formula. Not trying to type formula?...etc"

=VLOOKUP(AN2;'[Covid-19_report.xlsx]Hárok1';!$2:$42829;1,FALSE)

asked May 11 '20 at 19:55

Miroslav

2

Looks like you've got a `;` in the wrong place in `'[Covid-19_report.xlsx]Hárok1';!$2:$42829`... and also that `,` before `FALSE` should be a `;`. – BigBen May 11 '20 at 19:57
What you mean with that first ; where it should be ? I made it with function "Insert formula" @BigBen – Miroslav May 11 '20 at 20:00
1

`'[Covid-19_report.xlsx]Hárok1'!$2:$42829` - remove the `;`. – BigBen May 11 '20 at 20:02
I removed ; and it showed #N/A @BigBen – Miroslav May 11 '20 at 20:06
That means that the email address is not found in column A in those rows. – BigBen May 11 '20 at 20:08
But he should look in column B. Column A is status of email @BigBen – Miroslav May 11 '20 at 20:10
Then you need to use `INDEX/MATCH` or `XLOOKUP`. – BigBen May 11 '20 at 20:15
See here: https://stackoverflow.com/questions/38641040/excel-vlookup-where-the-key-is-not-in-the-first-column/38641090#38641090 – Scott Craner May 11 '20 at 20:22

0 Answers0