Posted to microsoft.public.excel.worksheet.functions

vsoler

external usenet poster

Posts: 79

Find a second value in a table with VLOOKUP

My table (range) contains, among other information, the code for a
team and the name of the person. Each team is made of 2 people.

I need to find the second person belonging to a team, which will not
be necessarily just below the first person.

Is there a way to find this second person. I do not mind using VLOOKUP
or any other function.

Thank you

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
Need help in formula - IF + Find + Vlookup	Dileep Chandran	Excel Worksheet Functions	5	November 2nd 06 05:59 AM
Use Vlookup to find less than today	Bruce	Excel Worksheet Functions	3	April 26th 06 10:05 PM
Vlookup & Find	Caroline	Excel Worksheet Functions	2	April 7th 06 03:13 PM
Vlookup to find Second INstance	[email protected]	Excel Worksheet Functions	1	September 16th 05 03:33 AM
Vlookup info being used without vlookup table attached?		Excel Worksheet Functions	0	January 25th 05 10:43 AM

All times are GMT +1. The time now is 01:30 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us