Re: Vlookup that checks against two values

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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.

.

Quantcast