| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two column value match table look up
I created a nifty database and report sheet workbook for my boss that
displays row fields from our large DBtable based on WorkOrderNunbers using =VLOOKUP(WorkOrderNunber,DBTable,ColNumToDisplay). Now he wants to have multiple "job" records for each work order. I could add a JobNo column next to the WorkOrderNunber column in the database table, but how can I do something like the above vlookup to search for lookup_value matches against two columns instead of just one column? Hope this problem description makes sense. Thx for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Need rows in Column A removed if they fully or partially match with any Column B row | Excel Discussion (Misc queries) | |||
| Value between 2 dates | Excel Worksheet Functions | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
| Lookup then Match and insert value from next column | Excel Worksheet Functions | |||
Threaded Mode
