Is it possible to enter multiple criteria in formulas.
e.g. something like this =DGET(Actual_Volumes,"Gate","Month"=C1&"Week"=D5)
or =VLOOKUP("Month"=C1&"Week"=D5,Actual_Volumes,2,FAL SE).
I need to extract data from a table with 2 or more criteria. I know I could
set up range adresses with the criteria but was hoping a simple AND/OR in the
formula line would suffice. Any help much appreciated