Vlookup that checks against two values

[runsrealfast]

I have a sheet that contains a column of Product numbers, a comlumn of
customer numbers, and a column for orders. In another sheet I have the
a similar format with the same columns. I need to check I need to move
the values of the order to the second sheet but I must check against
both the product number and the customer number. excel does not allow
you to do the following (gives the #NAME? error).

VLOOKUP(A1 AND B1, ANOTHERSHEETA1:C1,3,false)

What is the best way to do this?

John

 

[SteveM]

I have a sheet that contains a column of Product numbers, a comlumn of
customer numbers, and a column for orders. In another sheet I have the
a similar format with the same columns. I need to check I need to move
the values of the order to the second sheet but I must check against
both the product number and the customer number. excel does not allow
you to do the following (gives the #NAME? error).

VLOOKUP(A1 AND B1, ANOTHERSHEETA1:C1,3,false)

What is the best way to do this?

John

Convert your database to Access.


Really. If you are managing multi-product, multi-customer
information, Excel is probably the wrong platform. There are some
Access templates that will probably get you 80% there.

 

[trevosef]

I have a sheet that contains a column of Product numbers, a comlumn of
customer numbers, and a column for orders. In another sheet I have the
a similar format with the same columns. I need to check I need to move
the values of the order to the second sheet but I must check against
both the product number and the customer number. excel does not allow
you to do the following (gives the #NAME? error).

VLOOKUP(A1 AND B1, ANOTHERSHEETA1:C1,3,false)

What is the best way to do this?

John

Try populating a new column with the concatenated lookup fields and
use this as the lookup value instead of 2 separate fields. Repeat for
the lookup table.

Regards
Trevosef

 

[Dave Peterson]

Check your other posts, too.

I have a sheet that contains a column of Product numbers, a comlumn of
customer numbers, and a column for orders. In another sheet I have the
a similar format with the same columns. I need to check I need to move
the values of the order to the second sheet but I must check against
both the product number and the customer number. excel does not allow
you to do the following (gives the #NAME? error).

VLOOKUP(A1 AND B1, ANOTHERSHEETA1:C1,3,false)

What is the best way to do this?

John

 

[Stephen C]

Try - VLOOKUP(A1&B1,ANOTHERSHEET!A1:C1,3,false)

This will not work if both cells contain numbers.

 

[runsrealfast]

Convert your database to Access.

Really. If you are managing multi-product, multi-customer
information, Excel is probably the wrong platform. There are some
Access templates that will probably get you 80% there.

Actually the database is an oracle database. just have information
that needed to be undated and then we ran scripts to put the new data
in the DB.

Excel is in no way acceptable for a database.

John