Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On Jan 31, 5:45 pm, SteveM wrote:
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. 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |