multi criteria lookup

  1. A

    Multi Criteria Lookup

    Hello Experts, i have below dataset , which i need to filter with multiple ( criteria's and expected results mentioned below ) but in different worksheet. Suppler Name Part No Part Name Rate/ Pc Monthly Schedule ABC ABC1 test 1 10 339 XYZ XYZ2 test 2 10 677 ABC ABC3 test 3 8 236 CBZ...
  2. N

    Multi Criteria Lookup: Some criteria are text and one is a range of Numbers

    Hello, I am trying to create a lookup of some sort that has 4 criteria (3 are text and 1 a range of numbers). The result of the lookup will be text and ideally without the need for additional concatenation columns if possible. The last criteria is a range of numbers that is unique to the company...
    • NotoriousTAT
    • Thread
    • col lookup with ranges multi criteria lookup multi criteria match row
    • Replies: 2
    • Forum: Excel Questions

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