Match and index returning N/A
Please help with this I'm tearing my hair out. My table looks like this:
Gin Vodka Brandy Whisky
North 456 654 776 776
South 1000 764 965 464
East 532 642 642 1234
West 357 456 852 842
Gin starts in B1. I want to find out say, the Brandy sales for the East
using Index and match using the formula as follows:
The text in F6 is Brandy and in F7 East
=INDEX($A$1:$E$5,MATCH(F6,$A$1:$E$1,),MATCH(F7,$A$ 1:$A$5,))
This works OK for brandy and East but when I changed East to West I got 1234
then for Vodka for West I got 464. I can't understand what's going wrong, it
works for other tables.
Thanks in advance
Diane
|