Chris_Hatch

Posts: n/a

vlookup for same name, multiple instances...

I want to return the 2nd field for Jim in a single list:

Jim Dell
Jeff HP
Carl Compaq
Jim Toshiba
Carl Sony
Jim Lenovo
Jeff IBM

I want to pull Jim's accounts to another worksheet:

HP
Toshiba
Lenovo

When I use vlookup, it just returns HP and stops. How do I tell it to
return the next instance of Jim?

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 with Multiple Criteria?	Arturo	Excel Worksheet Functions	3	December 20th 04 06:59 PM
vlookup with multiple lines of same value	lostinexcel	Excel Worksheet Functions	1	December 17th 04 02:06 PM
vlookup over multiple worksheets	Neil	Excel Worksheet Functions	3	December 16th 04 08:19 PM
Can vlookup return multiple matches in a single cell?	cchristensen	Excel Discussion (Misc queries)	3	December 2nd 04 01:56 AM
Multiple Vlookup?	changeable	Excel Worksheet Functions	0	November 9th 04 11:52 AM

All times are GMT +1. The time now is 10:47 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us