INDEX/MATCH, two criteria multiple results

A

alexx579

New Member
Joined
Aug 19, 2014
Messages
44
Hi all,

I have the following formula I am using to pull a corresponding date:

=IFERROR(TRUNC(INDEX(ClosedOn,MATCH(A3&B3,ClosedName&ClosedMainAssignee, 0))),"N/A")

My question is this, I have exactly one situation in the subset of data where Ax & Bx are respectively the same twice. The formula is only pulling the first date from the named range "ClosedOn".

How can I modify the formula where it will pull the 1st and 2nd date for each duplciate?

Thanks for any help, I suspect this will be easy for most of you but I can't find a solution myself....:(

Again, thanks!!~AV
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
You must log in or register to reply here.

Similar threads

M
  • Question Question
A search formula (like index match) that can pull the most recent date when multiple matches may occur based on the criteria figure.
Replies
2
Views
146
MARZIOTULLIO
M
D
  • Question Question
If formula with date & VLOOKUP
Replies
1
Views
312
etaf
etaf
N
  • Solved
Help with formula please, if two values match calculate the difference between 2 dates
2
Replies
11
Views
465
Newbie73
N
G
  • Question Question
Index / Match multiple criteria and multiple results
Replies
0
Views
682
Glasgowsmile
G
T
  • Question Question
Pull data from multiple sheets that match varying criteria
Replies
1
Views
706
bobaol
B

Forum statistics

Threads
1,224,749
Messages
6,180,725
Members
452,995
Latest member
isldboy

Share this page

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