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? Commented Apr 10, 2018 at 12:59
  • So you want to look in column B for a match and return column A? Commented Apr 10, 2018 at 13:10
  • Yes @ScottCraner. Of course "2" will instead be replaced by "1".
    – Shred
    Commented 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
    Commented Apr 10, 2018 at 14:06
  • yes It is in there multiple times. Commented Apr 10, 2018 at 14:08
  • Just saw translated pages, not the original one. Tnx anyway.
    – Shred
    Commented Apr 10, 2018 at 14:28

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .