VLOOKUP - DOUBLE CRITERIA
 

Hi to All,

Hi,

I want to do a double vlookup, where I want to bring back
cost_of_sales to sheet 1, if the location and item# from sheet 2
matches with the location and item# from sheet1.

The layout is as follows:

sheet 1
location item_# average_inventory

Sheet 2
location item_# cost_of_sales

Can any one help - please.....

Thanks,

Rashid

=INDEX(Sheet2!C:C,MATCH(loc&item,A:A&B:B,0))

which is an array formula so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Rashid" wrote in message
m...
Hi to All,

Hi,

I want to do a double vlookup, where I want to bring back
cost_of_sales to sheet 1, if the location and item# from sheet 2
matches with the location and item# from sheet1.

The layout is as follows:

sheet 1
location item_# average_inventory

Sheet 2
location item_# cost_of_sales

Can any one help - please.....

Thanks,

Rashid

Correction

=INDEX(Sheet2!C:C,MATCHloc&item,Sheet2!A1:A200&She et2!B1:B200,0))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bob Phillips" wrote in message
...
=INDEX(Sheet2!C:C,MATCH(loc&item,A:A&B:B,0))

which is an array formula so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Rashid" wrote in message
m...
Hi to All,

Hi,

I want to do a double vlookup, where I want to bring back
cost_of_sales to sheet 1, if the location and item# from sheet 2
matches with the location and item# from sheet1.

The layout is as follows:

sheet 1
location item_# average_inventory

Sheet 2
location item_# cost_of_sales

Can any one help - please.....

Thanks,

Rashid

And see another option to your post in .excel.



Rashid wrote:

Hi to All,

Hi,

I want to do a double vlookup, where I want to bring back
cost_of_sales to sheet 1, if the location and item# from sheet 2
matches with the location and item# from sheet1.

The layout is as follows:

sheet 1
location item_# average_inventory

Sheet 2
location item_# cost_of_sales

Can any one help - please.....

Thanks,

Rashid

--

Dave Peterson