excel multiple lookup

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

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

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

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

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