Posted to microsoft.public.excel.worksheet.functions

deen

external usenet poster

Posts: 45

Vlookup multiple value

Eg:

In Sheet1 i have data like

Code No Amt

F0001 100
F0001 10
F0001 20
F0002 50
F0002 60
F0002 70
F0002 200

I Need result in sheet2 like,

Code No Amt
F0001 100
10
20

F0002 50
60
70
200

Pls Help Me,

Regards
Deen

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Vlookup for multiple criteria, multiple worksheets	jtoy	Excel Worksheet Functions	4	January 25th 07 09:26 PM
Multiple Ifs, can't use vlookup	[email protected]	Excel Discussion (Misc queries)	0	January 16th 07 10:38 PM
Vlookup multiple	dk	New Users to Excel	3	September 17th 06 04:59 AM
How do I use VLOOKUP to ref multiple workbooks with multiple tabs?	JackieW	Excel Discussion (Misc queries)	2	April 11th 06 05:32 PM
multiple vlookup	[email protected]	Excel Worksheet Functions	3	January 29th 06 03:29 PM

All times are GMT +1. The time now is 08:58 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us