Forum Discussion
vlook up on multiple drop down lists
SOLVED -Please see the table 1 below to calculate cost in the Table 2 according to variable values in the cells ( K4,L4,M4 ) ,using vlookup formula thanks!
You say you prefer a VLOOKUP formula, but don't provide a reason.
May I recommend instead (if you have the most recent release of Excel) the FILTER function.
=FILTER(G7:G19,(C7:C19=K8)*(D7:D19=L8)*(E7:E19=M8),"No match")
Those D____ functions are very nice and useful. They've been around in Excel for decades, yet very few users are aware of them. And they're probably functionally superseded now by such functions as FILTER (which, yes, is newer than your version, but a good reason to update your software). FILTER can be used in conjunction with other functions to do lots of things, but so long as you don't have it, it's worthwhile to be aware of these long-available tools for data retrieval (database functions)
- DGET, which will retrieve a value
- DSUM, which will retrieve the sum of multiple rows that meet a given set of criteria
- DAVERGE
- well, let me just refer you to this list: https://www.excelfunctions.net/excel-database-functions.html
- well noted , Thanks
