One shot at this ..

Assuming source data as posted is in a sheet: X, data from row2 down
with col A = Dept, col B = Pricetype, col C = Monthly av

In your other sheet,

Assume depts (NY, NJ, etc) are listed in A2 down,
Put this in B2, then array-enter the formula by pressing CTRL+SHIFT+ENTER
(instead of just pressing ENTER):
=INDEX(X!$C$2:$C$100,MATCH(1,(X!$A$2:$A$100=A2)*(X !$B$2:$B$100="Average"),0))
Copy B2 down to return the required figs from col C in X. Adapt the ranges
to suit.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"ruchie" wrote in message
ups.com...
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?