View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cinny Cinny is offline
external usenet poster
 
Posts: 19
Default Vlookup with Multiple criteria and multiple sheets

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