| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I lookup when match has more than one value?
Hi
Drag B to the Column area -- Regards Roger Govier G. wrote: Hi, I have used Pivot table and it only shows those 3 values in vertical way (1 column)..but i want the values to be shown horizontally (3 columns). Do you know if Pivot table can do that? Thanks, G. "ozgrid.com" wrote: Use a PivotTable http://www.ozgrid.com/Excel/excel-pivot-tables.htm -- Regards Dave Hawley www.ozgrid.com "G." wrote in message ... Hi I actually have another similar problem, can you help me? Hi I actually have a similar problem. Could you help me: Basically. I want to look up number 222222 in column A, and have it returns 3 values from column B which are 666666, 777777, and 9999999 in 3 separate column. Please help! 1....................A....................B 2..............123456...............1111111 3..............222222...............6666666 4..............222222...............7777777 5..............222222...............9999999 6..............444444...............8888888 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match and Lookup | Excel Worksheet Functions | |||
| using MATCH, and LOOKUP | Excel Worksheet Functions | |||
| match, lookup ??? | Excel Worksheet Functions | |||
| Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
| Lookup or Match | Excel Worksheet Functions | |||
![Roger Govier[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
