Mar 15 2024 11:39 AM
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?
Mar 15 2024 01:13 PM
SolutionLet'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.
Mar 15 2024 01:35 PM
Mar 15 2024 01:13 PM
SolutionLet'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.