| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking Up Datas when Key Values are Identical
Hi, Does anyone knows a function that I can lookup datas as below
Return data for look up Frank = MEP2-2, IAEMID-248, GABELLI-250, ML-248, CSFB-248 Return data for look up Sam = ML-2, UBS-4 Frank MEP2 2 Frank IAEMID 248 Frank GABELLI 248 Frank GABELLI 2 Frank ML 248 Frank CSFB 248 SAM ML 2 SAM UBS 4 Thank You! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List of values | Excel Discussion (Misc queries) | |||
| Referencing a specific number to more general values in a table. | Excel Worksheet Functions | |||
| values not appearing in autofilter list | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| How do I match identical values in 2 columns and then sort? | Excel Discussion (Misc queries) | |||
Threaded Mode
