multi dimensional lookup

  1. D

    Integrate extract record formula across multiple worksheets.

    I would like to search 5 unique product sheets (one at a time) through a drop down selection interface on a separate sheet. The search is based on 4 input criteria (length, width, height and mass) and match the closest record containing the next largest dimensions across these 4 individual...
    • digibay
    • Thread
    • index & match index array indirect multi dimensional lookup nearest
    • Replies: 0
    • Forum: Excel Questions
  2. R

    Vlookup based on lookup value and multi number criteria

    I have been stuck with this problem for a while. What I am trying to do is return a reason based on an Order. How it works is that an Order is placed and may have multiple line items which would have a total number of units but when the Order is actually selected, it is done so randomly but...
    • randrze2
    • Thread
    • multi criteria multi criteria match multi dimensional lookup vlookup
    • Replies: 0
    • Forum: Excel Questions
  3. L

    Multiple lookup-tables different for Pivot Table vs. Power View

    Hi I have a model with multiple many-to-many relationships between table columns. I've managed to solve this and get the wanted result when using Power View, but it's different when using conventional Pivot Tables. However, if applying a Calculated field (product -> Calculated field 1) it...
    • Lasselakan
    • Thread
    • calculated field multi dimensional lookup pivot table power view slicer
    • Replies: 2
    • Forum: Power Tools
  4. G

    how to find the 3rd largest number in a multi dimensional lookup

    Hi everyone, I would like to know where I would need to include the Large(array,number) function in the formula below in order to get the 3rd largest number from column "am". Please tell me what is needed to complete this.(thanks) =IF(COUNTIFS('Keyword report'!AM:AM,">0",'Keyword...

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