CODEWITHSUNDEEP
excelexcel-formulavlookup
wittman
wittman

Reputation: 305

Get email address from correspondent cell formula

I what to make a list with emails and when I put in cell A2 a name, in cell B2 should appear the address for that particular person. If the name is not in the list, cell B2 should have value 0 . With VLOOKUP it will return N/A if the name is not in the list.

enter image description here

Upvotes: 0

Views: 61

Answers (1)

user4039065
user4039065

Reputation:

Try,

=iferror(vlookup(a1, e:f, 2, false), 0)

The IFERROR function catches the non-match and provides a default value.

Upvotes: 3

Related Questions