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
.
|