Could you write down the best answer for common interview questions about MS Excel as far as you know or faced during an interview? Especially HR & HRIS Job-related!

if the column from which a value is to be retrieved changes (say, from the third to the fourth column) then the formula will return the wrong result.

Q. What does VLOOKUP do, and what might be better ways to do the same thing?

A. VLOOKUP retrieves a value from a table based on a lookup value to be found in the first column of the table, and the ordinal position — a hard-coded number — of the column from which the desired value is to be retrieved, from the same row as the lookup value. Its weakness is that if the column from which a value is to be retrieved changes (say, from the third to the fourth column) then the formula will return the wrong result. A better approach is INDEX and MATCH, used in combination, in which row and column numbers are determined by finding specified values in the table rows and columns from which the target value is to be retrieved. Still better is XLOOKUP, which works like INDEX and MATCH, but refers to ranges.