VLOOKUP question?

[Noir]

I have a workbook named "Production Inventory". This workbook has a series of serial numbers in Column L and a series of PO#'s in column B. In my second workbook named "Master List", I have all of the serial numbers (from Production Inventory column L)listed in column B.

I need to grab the PO#'s from Production Inventory column B and match them to the appropriate serial numbers in Master List column B. The PO#'s will be deposited into column S on Master List. (BTW, the serial numbers on Master List are no longer in the order per Production Inventory).

Any ideas?

Thx,
Noir

[Aladin Akyurek]

On 2002-05-01 11:54, Noir wrote:
I have a workbook named "Production Inventory". This workbook has a series of serial numbers in Column L and a series of PO#'s in column B. In my second workbook named "Master List", I have all of the serial numbers (from Production Inventory column L)listed in column B.

I need to grab the PO#'s from Production Inventory column B and match them to the appropriate serial numbers in Master List column B. The PO#'s will be deposited into column S on Master List. (BTW, the serial numbers on Master List are no longer in the order per Production Inventory).

Any ideas?

Thx,
Noir

In S2 in Master List enter:

=INDEX('Production Inventory'!$B$2:$B$40,MATCH(B2,'Production Inventory'!$L$2:$L$40,0))

Use dynamic name ranges if the ranges are not static.

[Noir]

Thanks Aladin!