| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup value one and retrieve more then one corresponding value fromanother sheet
hi,
In my excel sheet1 has value a2:d50 example: ColA-----------ColB-------------ColC---------ColD 4514012-------01.10.2008----------3pack014------2500 4514012-------15.08.2009----------2fctc012------1850 4514015-------01.02.2009----------3firewood-----2500 4514025-------02.03.2009----------3latex01------1500 so on, note: Numbers are repeated(ColA)and remaining are difference(ColB,ColC,ColD) In Sheet 2 has value A2:D50 Example: ColA-----------ColB-----------ColC---------ColD 4514012-------54140245------1ORIENT01-----200 4514012-------54140325------1MASHTR01-----850 4514015-------54140425------1CSTRAD01-----500 4514025-------54140525------1JANFUR01-----500 so on, I need following output: In Sheet1 ColE2 4514012-------54140245------1ORIENT01-----200 54140325------1MASHTR01-----850 ... 4514015-------54140425------1CSTRAD01-----500 4514025-------54140525------1JANFUR01-----500 please advise me, thx, EggHeadCafe - Software Developer Portal of Choice Developer Productivity as Science and Art http://www.eggheadcafe.com/tutorials...tivity-as.aspx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible to use the lookup function to retrieve objects? | Excel Discussion (Misc queries) | |||
| I NEED TO USE A LOOKUP FUNCT. TO RETRIEVE A PICTURE FROM A HYPERL | Excel Worksheet Functions | |||
| How to use lookup to retrieve next LARGEST value? | Excel Worksheet Functions | |||
| need to retrieve dates from lookup | Excel Discussion (Misc queries) | |||
| Data Validation fromanother sheet | Excel Discussion (Misc queries) | |||
Linear Mode
