Forum Discussion
Solved
INDEX MATCH Help!
Hi Everyone Wonder if someone could help me out :) I have tried (using google but i think I'm misunderstanding the logic) On Sheet one i have 2 columns 'C' and 'D' are Lists (generated from co...
gazzo1967 , you need two MATCH, one for the column and another one for the row, like
=INDEX('Mileage Chart'!A1:AP43,MATCH(C3,'Mileage Chart'!A1:AP1,0),MATCH(D3,'Mileage Chart'!A2:A43,0))
gazzo1967 , you need two MATCH, one for the column and another one for the row, like
=INDEX('Mileage Chart'!A1:AP43,MATCH(C3,'Mileage Chart'!A1:AP1,0),MATCH(D3,'Mileage Chart'!A2:A43,0))
Thank you for your help :) it makes sense as to why it would not work.
Very much appreciated :)
Gary