Re: Vlookup that checks against two values

On Jan 31, 5:45 pm, SteveM <sbm...@xxxxxxxxxxxx> wrote:
On Jan 31, 6:44 pm, runsrealfast <runsrealf...@xxxxxxxxxxx> wrote:

I have a *** that contains a column of Product numbers, a comlumn of
customer numbers, and a column for orders. In another *** 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 *** 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.

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
.