Skip to content

Excel Search by Multiple Criteria

If you have a list of horizontal data and you want to turn it into vertical data then you need to use the index() function. As in the example below.

First, prepare a list of two non-repeating values, in my case “Nazwa” and “Kwota”. Then a list of recurring values to help with the search, I search by the “Etap” column.

The formula in the “Adres” column looks like this:


Nothing special. The real magic begins after this column. Index() function supported by Match().


Remember to confirm the index() function using the key combination Crtl+Shift+Enter.

Comments are closed, but trackbacks and pingbacks are open.