Hi Diane

Index wants the Row value first, followed by the Column Value.
You have your formula the other way around.
Change to
=INDEX($A$1:$E$5,MATCH(F7,$A$1:$A$5,0),MATCH(F6,$A $1:$E$1,0))

--
Regards
Roger Govier

"DianeG" wrote in message
...
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