INDEX & MATCH (Excel 2003 SP3)

[steveh]

Good morning

I have a matrix D5:M14 (screenshot below) with the zones across the top named as zonala and the zones down the side named as zonalb. I the have 2 Comboboxes both with adjacent cells I20 & P20 that return Zones based on the Countries selected in the Comboboxes.

I have tried to write a formula but I am getting #N/A which does not surprise me because it is the first time that I have tried to write this type of formula, the formula is

=INDEX(D5:M14,MATCH(Zonala,I20),MATCH(Zonalb,P20))

[HansV]

Try

=INDEX(D15:M14,MATCH(I20,Zonala,0),MATCH(P20,Zonalb,0))

In the MATCH function, the first argument is the value you're looking for, the second argument is the range to look in, and the third argument indicates how to search; 0 specifies that you're looking for an exact match.

[steveh]

Hi Hans

Thank you very much, I can't beleive I was so close, there might be hope for me yet!!