Forum Discussion
Vlookup help With three indirect drop downs
Here is the template I am working with. On Report tab I want to be able to 1) select customer then 2) select date and then 3) the Project#.
The report auto-completes with the information retrieved from the vlookup.
I can get the customer vlookup to work but not the second and third criteria.
Any help would be appreciated
KAB525 Here's an altogether different solution to your problem, one using the seldom used (but quite powerful) database functions within Excel. There's a whole set of functions that begin with the letter D, such things as DSUM, DAVERAGE, DMIN, DMAX..... this uses only the very simple DGET to retrieve the data elements you want from your database . You asked for three criteria, so this is set up with those three possible, but so long as you have a unique Customer name (i.e., only used once) or unique Project Number, you really need enter only that one field. But if you have two rows for the same customer, then you'll need to differentiate it by using a project number. There's a text box on the sheet that gives a little more complete explanation, but feel free to write back if you have questions.
I use a spreadsheet like this, with many many rows, to create invoices for consulting, with separate rows (a variable number of them in any given invoice) for different types of consulting, and with DSUM to total hours by category....... and then factor in a per hour billing rate to arrive at a final invoice. It works like a charm.