Forum Discussion
Using VLOOKUP Question
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 🙂
