Ive been trying to figure this out ALL day! How do I do an Index_Match Formula where Column P has multiple values for the Index? See below
Column P
$650.00 (Row12)
$800.00 (Row 24)
My current formula
=INDEX($P$4:$P$31,MATCH(AH12,$AH$4:$AH$31,0))
The zero at the end of the above formula will only provide the value for the 1st
How can I get it to do for both values
Column AH Values are
9 (Row12)
17 (Row24)
So in Column AI it should show
Row 12 as 650.0
Row 24 as 800.00
Hope you can understand and can provide guidance.
Bookmarks