| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Lookup return 1 result
Hello,
I have the following scenario where I want to match the two columns in Sheet1, with the columns Code and State in Sheet2, but list the Branch found in Sheet2. I would like the Branch to populate a column in Sheet1. Thanks for your help. Sheet1: Ref State 0 CA 0 FL 0 MD 13 NV 144 TX Sheet2: Code Branch State 0 NJP33 NJ 13 NVP22 NV 144 TXP62 TX |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup value then return result from other column, varying row num | Excel Worksheet Functions | |||
| lookup for a value in multiple columns and return a result | Excel Discussion (Misc queries) | |||
| Lookup 3 columns and return a result from another column | Excel Discussion (Misc queries) | |||
| lookup value and return result in column to left | Excel Worksheet Functions | |||
| I need a Lookup to return more than 1 result | Excel Worksheet Functions | |||
Threaded Mode
