Index & Match Multiple Criteria Why is this not Formula Working Headache

daleholden

Board Regular
Joined
Sep 22, 2002
Messages
243
HI Guys

Been trying for hours to insert an invoice number by matching date & price.
I though Index match was the obvious choice but not sure why I am not getting the result I need.
Followed about 3 tutorials from YouTube but mine not working when i think it should.

I had the in separate Worksheets first then to make it easier moved it same worksheet but no luck

So guys what am I doing wrong?

Extract%20Invoice%20Number.jpg
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
Hi

I have even tried =INDEX(Customers!A2:$A$790,MATCH(D6,Customers!B2:B790,0),MATCH(I6,Customers!D2:D790,0))

Still not working!!!
 
Upvote 0
try (confirm with shift-control-return)

=INDEX(Customers!A2:$A$790,MATCH(D6&"/"&I6,Customers!B2:B790&"/"&Customers!D2:D790,0))
 
Upvote 0
Hi AlanY

Cheers mate it works can you just tell me why mine didn't work i see you have used "/" not seen this used before ??

Note it is not going to work as I have several items same price on the same date all get the same invoice number. I guess it is not individual enough
 
Upvote 0
I'd used the "/" as the seperator to combiner the 2 match() criteria in your original index() function.
 
Upvote 0

Forum statistics

Threads
1,213,491
Messages
6,113,963
Members
448,536
Latest member
CantExcel123

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