Vlookup problem

[ruchie]

I have to search and put values in one of my sheets after looking in
a
field of a field. I believe i need to to a nested vlookup, but im not
sure how to go about it. I copied the relevant portions of the data
below:

Department PriceType Monthly
Average


NY
NY Average $1,000.00
NJ
NJ
NJ
NJ
Average $1,500.35


I have to search within a department (for example NJ), and then
search
where average is occuring in the Price Type field, and then pick the
corresponding Monthly average value(1500.35 in this case) and put it
in the vlookup formula origination sheet.
Any help?

 

[Roman]

I would add a column with function "concatenate" (to connect
Department and PriceType values) and then use vlookup to search for
e.g. "NYAverage" in the new column.

ruchie napsal:

 

[Roman]

An array SUM function would work for you as well
{=SUM((A2:A7="NY")*(B2:B7="Average")*(C2:C7))}

Roman napsal: