On Jan 31, 6:44 pm, runsrealfast wrote:
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.