Is it possible to to use vlookups with multiple arrays?

On sheet 1, starting in A1 I have a list of order numbers, in column B I
have the coresponding Part No. and in column C I have the person responisble
for this item.

On sheet 2 I have the same information in columns A & B but need to use V
lookup to populate column C the the person responisble. i.e lookup both
columns A & B.

Is this possible?

Hi

One way
Add an extra column to sheet 1 with the formula
=A1&"|"&B1
copy down as far as required.
On sheet 2, in C1
=INDEX(Sheet1!C:C,MATCH(Sheet2!A1&"|"&Sheet2!B1,Sh eet1!D:D))
--
Regards
Roger Govier



"The Rook" wrote in message
...
Is it possible to to use vlookups with multiple arrays?

On sheet 1, starting in A1 I have a list of order numbers, in column B I
have the coresponding Part No. and in column C I have the person
responisble
for this item.

On sheet 2 I have the same information in columns A & B but need to use V
lookup to populate column C the the person responisble. i.e lookup both
columns A & B.

Is this possible?