1

I notice this problem while using this vlookup function in excel 2016:

=IFERROR(VLOOKUP(A:A,Sheet2!A:B,2,FALSE),"NO MATCHING")

So the function will check into the range A:B, and if the match is confirmed, it'll print the value on the second column. Now, my worksheet have got similar values (according to the ones in "A" column of Sheet1) on the column "A" of the Sheet2: if I invert the position of A and B column into the Sheet2 , it will print always the iferror's message "NO MATCHING".

Why this difference?

3
  • Does your VLOOKUP return "NO MATCHING" in all cases? Apr 10, 2018 at 12:59
  • So you want to look in column B for a match and return column A? Apr 10, 2018 at 13:10
  • Yes @ScottCraner. Of course "2" will instead be replaced by "1".
    – Shred
    Apr 10, 2018 at 13:32

1 Answer 1

3

You will need to use INDEX/MATCH as VLOOKUP requires the lookup value to be in left column.

=IFERROR(INDEX(Sheet2!A:A,MATCH(A:A,Sheet2!B:B,0)),"")
3
  • Oh, that's what I suspected. Is there some place in Documentation reporting this condition?
    – Shred
    Apr 10, 2018 at 14:06
  • yes It is in there multiple times. Apr 10, 2018 at 14:08
  • Just saw translated pages, not the original one. Tnx anyway.
    – Shred
    Apr 10, 2018 at 14:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.