

Insert Function Wizard with VLOOKUP
Roman Kondratiuk
MATCH can be used instead of a LOOKUP function when you need to determine the position of a value in a list instead of the value itself.
As an example, you may use the MATCH function to provide a value to be used in the row_num argument of the INDEX function.