CODEWITHSUNDEEP
excelvlookup
acctman
acctman

Reputation: 4349

VLookup to get value is there is a match

When attempting this vlookup formula I am receiving #n/a how can I fix this. If a match is found in Column A then copy the address from Column B to Column F's matching user.

enter image description here

Upvotes: 0

Views: 311

Answers (2)

Harun24hr
Harun24hr

Reputation: 36780

Avoid VLOOKUP() instead use INDEX/MATCH() combination. To ignore errors wrap the whole formula with IFERROR() function. Try-

=IFERROR(INDEX($B$2:$B$10,MATCH(C2,$A$2:$A$10,0)),"")

enter image description here

Upvotes: 1

Orange_guy
Orange_guy

Reputation: 1

If I understood right, you match the columns "LogID" and "UserID", right? This could give you the values at "Match Result" ("F"). Well, for me doesn't make much sense not getting the result on the 2nd cell of "F", since there is a pair on "A". But for the first cell of "F", you will not receive any answer, since there is no "bb101" (UserID) on LogID

Upvotes: 0

Related Questions