Posted to microsoft.public.excel.misc

Carolina Girl Carolina Girl is offline

external usenet poster

Posts: 25

multiple answers

Help€¦ Dont know if I can explain this correctly€¦.. I am looking for a
formula that will do a vlookup on another sheet and tell me multiple answers.
If there are two columns in sheet 1 and 123 shows up twice what I need on
sheet 2 is columns Bs information for 123 to show up with each time it is
listed
Sheet 1
A B
123 xyz
132 hig
123 jkl

Sheet 2
A B C
123 xyz jkl

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
Get multiple answers from a table	Curt D.	Excel Worksheet Functions	4	March 9th 08 08:06 PM
creating multiple answers	kinsey	Excel Discussion (Misc queries)	4	November 21st 07 10:03 PM
vlookups with multiple answers	Jen	Excel Discussion (Misc queries)	4	July 10th 07 12:20 PM
multiple answers	AndyS	Excel Worksheet Functions	3	October 16th 06 09:14 AM
IF function for multiple answers?	fastballfreddy	Excel Worksheet Functions	3	April 30th 06 08:11 PM

All times are GMT +1. The time now is 11:51 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us