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
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Maybe...

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

M.
 
Upvote 0

Forum statistics

Threads
1,213,526
Messages
6,114,122
Members
448,550
Latest member
CAT RG

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top