| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup that checks against two values
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup multiple values - sum returned values into single cell | Excel Worksheet Functions | |||
| Vlookup that checks against two values | Excel Worksheet Functions | |||
| Checks whether a value is text or number | Excel Worksheet Functions | |||
| Different colored checks?? | Excel Discussion (Misc queries) | |||
| Formula/function that checks for a set of values. | Excel Worksheet Functions | |||
Threaded Mode
