Forum Discussion
Solved
Using VLOOKUP Question
I have 2 tabs on a spreadsheet. The first one lists all people in a certain category and their email addresses, the second lists only the ones that need to be contacted. I thought I could use VLOOKUP to pull the email addresses from the first tab for only those listed in tab 2 but I'm having trouble with the formula. Does this make sense?
Let's say the names are in column A on a sheet named All People, and the email addresses in column E.
On the second sheet, names are also in column A, from A2 down.
In B2:
If you have Microsoft 365 or Office 2021:
=XLOOKUP(A2, 'All People'!A:A, 'All People'!E:E, "")
In older versions:
=IFERROR(VLOOKUP(A2, 'All People'!A:E, 5, FALSE), "")
The 5 in this formula specifies that the email address should be retrieved from the 5th column of range A:E.
In both cases, fill down.
Let's say the names are in column A on a sheet named All People, and the email addresses in column E.
On the second sheet, names are also in column A, from A2 down.
In B2:
If you have Microsoft 365 or Office 2021:
=XLOOKUP(A2, 'All People'!A:A, 'All People'!E:E, "")
In older versions:
=IFERROR(VLOOKUP(A2, 'All People'!A:E, 5, FALSE), "")
The 5 in this formula specifies that the email address should be retrieved from the 5th column of range A:E.
In both cases, fill down.
- Thank you so so so much!!! Exactly what I wanted to do 🙂
