This is a question to give an end to a discussion between me and the rest of my work friends, since we use the VLOOKUP formula differently. Can anyone help us?
Basically, when I use this formula, my first element, equivalent to the search_value, is always the column that has the values I’m looking for, for example:
=VLOOKUP(@A:A;Test!A:A;1;FALSE)
In comparison, my coworkers only use the column row value, like this:
=VLOOKUP(A2;Test!A:A;1;FALSE)
They argue with me that my formula is a “gimmick” that shouldn’t work, but it does. I think my formula makes perfect sense and is coherent. I also believe that it works because of the @ in front of the column, but I don’t have enough technical knowledge to say what this does exactly.
Is my way wrong? Is it a “workaround” or is it also correct and makes sense?
Both ways results in the same values, so I don’t know what to think :/
user26619563 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.