# excel multiple lookup

1. ### Lookup Multiples from Exploded BOM Lines and return units used

Hi there I wonder if someone can help, Im a bit of a novice and learning my way, I have an exploded BOM from assembled products direct from a data source with various components and quantities that make up the assembled product. I am looking for a way that I can look up from a long list of...
2. ### Multiple Lookups & Formula

Hello I am trying to do a multiple figure lookup to calculate a loan fee. The Property Value and Loan Amount values are variables, and the Percentage is calculated as Loan / Value. To calculate the loan fee, I need to match the Loan Amount on the horizontal axis, and the Percentage on the...
3. ### Excel lookup using multiple criteria

Hi, Below is a sample table which I need to extract data from: <tbody> Event Name Location Feb Feb Feb Feb Feb Feb Feb Feb 04-Feb 05-Feb 06-Feb 07-Feb 08-Feb 09-Feb 10-Feb 11-Feb Event-1 Loc-1 Yes Yes Yes Yes Loc-2 Yes Yes Yes Yes Loc-3 Yes Event-2 Loc-1 Yes Yes...
4. ### Excel: Return multiple corresponding values for multiple lookup values

Hello, I'm sorry if this question has been asked already but I've been looking for an answer for a while to no avail. I would like to know how to lookup multiple values using multiple criteria. Let us say that in column A are last names, in column B are first names, and in column C are phone...
5. ### VLOOKUP MULTIPLE COLUMNS

With the knowlege that I have of Excel, VLOOKUP is the best function I know of to look up and match to other data in a workbook. If there is another way to do this please let me know. I need to use 2 columns in a data array to match in order to be supplied with the correct item number that is...

### 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.

### Which adblocker are you using?

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

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