Lookup with Index & Match multiple criterias

B

bryanhope

New Member
Joined
Mar 22, 2017
Messages
4
Hello I am trying to create some lookups with multiple criterias see the links for screenshots of what I am trying to do.


https://photos.app.goo.gl/mAuxs438hFUOjQZw1

https://photos.app.goo.gl/C9em194jvajqCEfy2


C9em194jvajqCEfy2

mAuxs438hFUOjQZw1

mAuxs438hFUOjQZw1
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

R
  • Solved
Matching multiple criteria that includes comma separated value
Replies
2
Views
196
Rokcmd
R
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
152
MARZIOTULLIO
M
B
  • Solved
Return Last Value in Range Using INDEX MATCH
Replies
3
Views
371
Alex Blakenburg
A
A
  • Question Question
Excel - looking up data with multiple criteria from table/array, date must be same or nearest before the target cell
Replies
8
Views
627
Peter_SSs
Peter_SSs
A
  • Solved
Index Match With Multiple Criteria
Replies
3
Views
318
acool
A

Forum statistics

Threads
1,224,823
Messages
6,181,177
Members
453,021
Latest member
Justyna P

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