excel vlookup blahness

[cell22]

So I am trying to make a price sheet off of an excel spreadsheet. I am trying to make lookup commands that looks up the name of the cabinet in column E. Then it will check the dimensions (columns f,g,h) to determine the price of the cabinet. A problem is that the pricing will change from square foot linear foot, specific dimensions to range of dimensions, and that there are a potential of hundreds of optional names for column e.
Any help or clues to the answer would be greatly appreciated as I can't seem to get anywhere with it. Thank you so much in advance.
-Ian

[tuph]

You need a lookup table (probably in another worksheet) that contains rows of data containing unique combinations of columns E:H and a column for price calculations. Then column I in your job/purchase order worksheet can use VLOOKUP to find the price in the lookup table.

[WinteE]

Hi Ian,

Om my site you'll find a MLOOKUP() function. This is a User Defined Function with which you can lookup on multiple criteria.
There's a sample on my site as well as a brief description how to create this function in your Excelsheets.

Erik

[cell22]

Thank you both for your suggestions. I will try both ways.

[tuph]

Hi Ian,

Om my site you'll find a MLOOKUP() function. This is a User Defined Function with which you can lookup on multiple criteria.
There's a sample on my site as well as a brief description how to create this function in your Excelsheets.

Erik

Erik,

Thanks so much for your simple solution to the 2-way lookup problem. I have over 60 workbooks, most with multiple worksheets, and they're all linked using VLOOKUPs that have to be edited every month. You're a life saver!