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

Mighty_Mitchell

New Member
Joined
May 15, 2019
Messages
11
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

MrExcel MVP
Joined
Aug 23, 2010
Messages
16,332
Maybe...

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

M.
 

Forum statistics

Threads
1,084,819
Messages
5,380,090
Members
401,645
Latest member
Me22

Some videos you may like

This Week's Hot Topics

Top