Vlookup with Multiple criteria and multiple sheets
Cinny
Insert a column in A to produce a unique reference. In A2 type =B2&C2 and
copy down. Sort the list on reference and use VLOOKUP in the normal way. Your
budget will be in column 9 (I)
Peter
"Cinny" wrote:
Hi
I have a worksheet with a summary page like
Column A Customer name
Column B Industry and in colum H I want to return a budget figure based on
the two criteria of Column A & B. The budget figure is in another sheet
where column A & B once again have the customer name and Industry and the
budget figure is in column C. How do I get the figure from the second sheet
in column C using the multiple criteria into the first sheet? hope this
makes sense.
Cinny
|