Well this is where the INDEX-MATCH formula comes in and gives you a helping hand. Put a comma after the right parenthesis of the MATCH function. The MATCH function searches for a specified item in a range of cells and then returns the relative position of that item in the range.
INDEX MATCH Function in Excel.
In the example shown the formula in I7 is. It searches the row position of a valuetext in one column using the MATCH function and returns the valuetext in the same row position from another column to the left or right using the INDEX function. The combination of the INDEX and MATCH functions are used twice in each formula first to return the invoice number and then to return the date. INDEX MATCH Function in Excel.