| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
multiple lookups - xls2003
I am close to getting this formula correct but can't seem to get it just right.
sheet1 I have: Customer Name Line 1 Address City State Zip ACADIA PHARMACEUTICALS SAN DIEGO CA 92121 ALEXION ANTIBODY SAN DIEGO CA 92121 UNIVERSITY OF SOUTH MOBILE AL 36688 UNIVERSITY OF SOUTH MOBILE AL 36688 sheet2 I have a defined name for my data called "products" This sheet contains data such as: Zip Name City State Rep 92121 ACADIA PHARMACEUTICALS SAN DIEGO CA RHENSLEYPA 92121 ACADIA PHARMACEUTICALS SAN DIEGO CA RHENSLEYPA 92121 ADVENTRX PHARMACEUTICALS SAN DIEGO CA RCATONMA Even though the zip is the same in sheet2 I need to show the different Rep name based on the different customer name. I have my formula like this: =INDEX(D3,MATCH(1,(products)*(A3)*(products),0)) What am I doing wrong? Thank you in advance! Rogers |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookups vs Match | Excel Worksheet Functions | |||
| Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
| adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
| Return Multiple Results with Lookup | Excel Worksheet Functions | |||
| XML / parent with multiple children and with multiple children | Excel Discussion (Misc queries) | |||
Threaded Mode
