| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multi Column Lookup
I have a sheet with accounting data from MS SQL Server.
Fields include BudgetID, Period, and the account numbers in three seperate fields ActNumbr_1, ActNumbr_2, and ActNumbr_3. I need a lookup like this on the multiple columns: BudgetID contains "FY04" Period = 2 ActNumber_1 = "100" ActNumber_2 = "3000" ActNumber_3 = "01" Any suggestions on how I can do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to find a value with multi-column, multi-record list | Excel Worksheet Functions | |||
| Multi column lookup | Excel Discussion (Misc queries) | |||
| How to create a multi column lookup list? | Excel Worksheet Functions | |||
| match in multi-column and multi-row array | Excel Discussion (Misc queries) | |||
| Extract values from a multi-select multi-column list-box | Excel Programming | |||
Threaded Mode
