VLookup to get value is there is a match-CodePudding

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.

CodePudding user response：

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)),"")

CodePudding user response：

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