I am trying to index match with three different table ranges. I am apply the following formula in
B16=IF(MATCH(A$15,$A$2:$B$2,0),VLOOKUP($A16,$A$3:$B$12,2,0)) the formula working fine but the problem is every time I have change table ranges. I
need one formula for whole table range...