| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup Returning Multiple Results
In my Workbook I have a sheet called MASTER and it has the information I am wanting to extract. In Cell AQ6 I have this "YHMIA.2615.1.400" For each SKU# I have maybe 3 to 6 DIE's. I want to return the DIE #, DIE LOCATION, & DIE TYPE in a horizontal manor. Can this be done? Any help would be appreciated. Please see the example below for what I am wanting. AQ6 = "YHMIA.2615.1.400" This is SKU# AR6 = "E" THIS IS DIE TYPE AS6 = "8022" THIS IS DIE LOCATION AT6 = "122" THIS IS DIE # AU6 = "D" THIS IS THE SECOND DIE TYPE AV6 = "8321" THIS DIE's LOCATION AW6 = "122" THIS DIE's # -- joe1182 ------------------------------------------------------------------------ joe1182's Profile: http://www.excelforum.com/member.php...o&userid=30977 View this thread: http://www.excelforum.com/showthread...hreadid=506454 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop Down Menu and multiple results | Excel Discussion (Misc queries) | |||
| Multiple lookup values in =HLOOKUP | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Multiple lookup value's | Excel Worksheet Functions | |||
| Multiple Criteria Lookup Question | Excel Discussion (Misc queries) | |||
Threaded Mode
