Index Match Match.... It just wont work :(

[Mighty_Mitchell]

I am an avid VLookup user and have recently learned of all the benefits of Index Match and Index Match Match.... I just cant seem to get it to work on my workbook!
I would be extremely grateful if someone would be able to help me.

On tab named 'Database' I have a table of data in cells A4:EV7 (limited data at the moment but it will grow in time).
The client name is in column A and the headers are in row 4. I have named the Column A:A 'ClientName' and named the row A4:EV4 'Headers'.

On another tab, I have a table with headers across the top (Row 5) and Client Names down the left side (column A).

I would like to use Index Match Match to populate my table.


I have tried the below formula - returning #REF ! as a value and I cannot work out why!

=INDEX(Database!$A$4:$EV$7,MATCH(A8,ClientName,0),MATCH(B5,Headers,0))

I have tried the MATCH formula on its on and this has worked.
IE =MATCH(A6,ClientName,0) and =MATCH(B5,Headers,0)
But it fails each time I try to add the Index Function.

I have also tried to remove one of the Match formulae
=INDEX(Database!$A$4:$EV$7,MATCH(A8,ClientName,0),5)

Thank you in advance

 

[Marcelo Branco]

Maybe...

=INDEX(Database!$A$4:$EV$7,MATCH(A8,Database!$A$4:$A$7,0),MATCH(B5,Database!$A$4:EV$4,0))

M.

 

[Mighty_Mitchell]

YOU LEGEND!!!!!!!
Thank you so much Marcelo! Eternally grateful

 

[Marcelo Branco]

You are welcome. Glad to help.

M.