Forum Discussion
Newly updated Spill function broke my indexing formula
I use the formula =INDEX(Column I want value returned from,MATCH(Column with value to match,other column with value to match,0)) a lot in my work. Usually to return a value for the price stored in th...
Using your own notation, I believe you need to write the formula this way:
=INDEX(Column I want value returned from,MATCH(Cell with value to match,Column with value to match from,0),1)
Or:
=INDEX(B:B,MATCH(C1,A:A,0),1)where Col A holds part numbers, Col B prices and Col C will have the parts for which you want to match the prices.