SOLVED

# Using VLOOKUP Question

Copper Contributor

# 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?

2 Replies
best response confirmed by jlm3965 (Copper Contributor)
Solution

# Re: 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.

# Re: Using VLOOKUP Question

Thank you so so so much!!! Exactly what I wanted to do :)
1 best response

Accepted Solutions
best response confirmed by jlm3965 (Copper Contributor)
Solution

# Re: 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.