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")
