Beyond VLOOKUP Clarification

[nebb]

[U]Example Table[/U]
A B C D
1 83 Vermont Doctor Doe
2 120 Connecticut Clerk Jones
3 145 Vermont Nurse Jones
4 202 Indiana Student Jones
5 101 Massachusetts Store Keeper Lee
6 24 Maine Accountant Smith
The above table is sorted on column D.

If , for example, I used the following formula on the above table:
=vlookup( 120,A1:D6,4,false)
the formula would return the name “Jones” found in cell D2

Question: Is there someway that, after using the above vlookup formula,
(1) To test to see if there are additional entries with the same name as returned by the vlookup formula and
(2) For each same name entry, show the information in column C.

[Tom Ogilvy]

Why not use an Advanced Filter. (Data=>Filter=>Advanced Filter)

--
Regards,
Tom Ogilvy

"nebb" <[email protected]> wrote in message
news:[email protected]...
>
> _[U]Example_Table[/U_]
> A B C D
> 1 83 Vermont Doctor Doe
> 2 120 Connecticut Clerk Jones
> 3 145 Vermont Nurse Jones
> 4 202 Indiana Student Jones
> 5 101 Massachusetts Store Keeper Lee
> 6 24 Maine Accountant Smith
> The above table is sorted on column D.
>
> If , for example, I used the following formula on the above table:
> =vlookup( 120,A1:D6,4,false)
> the formula would return the name "Jones" found in cell D2
>
> Question: Is there someway that, after using the above vlookup
> formula,
> (1) To test to see if there are additional entries with the same name
> as returned by the vlookup formula and
> (2) For each same name entry, show the information in column C.
>
>
> --
> nebb
> ------------------------------------------------------------------------
> nebb's Profile:
http://www.excelforum.com/member.php...fo&userid=8981
> View this thread: http://www.excelforum.com/showthread...hreadid=384193
>

[Alan Beban]

=INDEX($C$1:$C$6,SMALL(IF($D$1:$D$6=VLOOKUP(120,$A$1:$D$6,4),ROW($D$1:$D$6)),ROW(A1)))

aray entered and filled down.

Alan Beban

nebb wrote:
> _[U]Example_Table[/U_]
> A B C D
> 1 83 Vermont Doctor Doe
> 2 120 Connecticut Clerk Jones
> 3 145 Vermont Nurse Jones
> 4 202 Indiana Student Jones
> 5 101 Massachusetts Store Keeper Lee
> 6 24 Maine Accountant Smith
> The above table is sorted on column D.
>
> If , for example, I used the following formula on the above table:
> =vlookup( 120,A1:D6,4,false)
> the formula would return the name “Jones” found in cell D2
>
> Question: Is there someway that, after using the above vlookup
> formula,
> (1) To test to see if there are additional entries with the same name
> as returned by the vlookup formula and
> (2) For each same name entry, show the information in column C.
>
>

[Tom Ogilvy]

Why not use an Advanced Filter. (Data=>Filter=>Advanced Filter)

--
Regards,
Tom Ogilvy

"nebb" <[email protected]> wrote in message
news:[email protected]...
>
> _[U]Example_Table[/U_]
> A B C D
> 1 83 Vermont Doctor Doe
> 2 120 Connecticut Clerk Jones
> 3 145 Vermont Nurse Jones
> 4 202 Indiana Student Jones
> 5 101 Massachusetts Store Keeper Lee
> 6 24 Maine Accountant Smith
> The above table is sorted on column D.
>
> If , for example, I used the following formula on the above table:
> =vlookup( 120,A1:D6,4,false)
> the formula would return the name "Jones" found in cell D2
>
> Question: Is there someway that, after using the above vlookup
> formula,
> (1) To test to see if there are additional entries with the same name
> as returned by the vlookup formula and
> (2) For each same name entry, show the information in column C.
>
>
> --
> nebb
> ------------------------------------------------------------------------
> nebb's Profile:
http://www.excelforum.com/member.php...fo&userid=8981
> View this thread: http://www.excelforum.com/showthread...hreadid=384193
>

[Alan Beban]

=INDEX($C$1:$C$6,SMALL(IF($D$1:$D$6=VLOOKUP(120,$A$1:$D$6,4),ROW($D$1:$D$6)),ROW(A1)))

aray entered and filled down.

Alan Beban

nebb wrote:
> _[U]Example_Table[/U_]
> A B C D
> 1 83 Vermont Doctor Doe
> 2 120 Connecticut Clerk Jones
> 3 145 Vermont Nurse Jones
> 4 202 Indiana Student Jones
> 5 101 Massachusetts Store Keeper Lee
> 6 24 Maine Accountant Smith
> The above table is sorted on column D.
>
> If , for example, I used the following formula on the above table:
> =vlookup( 120,A1:D6,4,false)
> the formula would return the name “Jones” found in cell D2
>
> Question: Is there someway that, after using the above vlookup
> formula,
> (1) To test to see if there are additional entries with the same name
> as returned by the vlookup formula and
> (2) For each same name entry, show the information in column C.
>
>

[Tom Ogilvy]

Why not use an Advanced Filter. (Data=>Filter=>Advanced Filter)

--
Regards,
Tom Ogilvy

"nebb" <[email protected]> wrote in message
news:[email protected]...
>
> _[U]Example_Table[/U_]
> A B C D
> 1 83 Vermont Doctor Doe
> 2 120 Connecticut Clerk Jones
> 3 145 Vermont Nurse Jones
> 4 202 Indiana Student Jones
> 5 101 Massachusetts Store Keeper Lee
> 6 24 Maine Accountant Smith
> The above table is sorted on column D.
>
> If , for example, I used the following formula on the above table:
> =vlookup( 120,A1:D6,4,false)
> the formula would return the name "Jones" found in cell D2
>
> Question: Is there someway that, after using the above vlookup
> formula,
> (1) To test to see if there are additional entries with the same name
> as returned by the vlookup formula and
> (2) For each same name entry, show the information in column C.
>
>
> --
> nebb
> ------------------------------------------------------------------------
> nebb's Profile:
http://www.excelforum.com/member.php...fo&userid=8981
> View this thread: http://www.excelforum.com/showthread...hreadid=384193
>

[Alan Beban]

=INDEX($C$1:$C$6,SMALL(IF($D$1:$D$6=VLOOKUP(120,$A$1:$D$6,4),ROW($D$1:$D$6)),ROW(A1)))

aray entered and filled down.

Alan Beban

nebb wrote:
> _[U]Example_Table[/U_]
> A B C D
> 1 83 Vermont Doctor Doe
> 2 120 Connecticut Clerk Jones
> 3 145 Vermont Nurse Jones
> 4 202 Indiana Student Jones
> 5 101 Massachusetts Store Keeper Lee
> 6 24 Maine Accountant Smith
> The above table is sorted on column D.
>
> If , for example, I used the following formula on the above table:
> =vlookup( 120,A1:D6,4,false)
> the formula would return the name “Jones” found in cell D2
>
> Question: Is there someway that, after using the above vlookup
> formula,
> (1) To test to see if there are additional entries with the same name
> as returned by the vlookup formula and
> (2) For each same name entry, show the information in column C.
>
>

[Alan Beban]

=INDEX($C$1:$C$6,SMALL(IF($D$1:$D$6=VLOOKUP(120,$A$1:$D$6,4),ROW($D$1:$D$6)),ROW(A1)))

aray entered and filled down.

Alan Beban

nebb wrote:
> _[U]Example_Table[/U_]
> A B C D
> 1 83 Vermont Doctor Doe
> 2 120 Connecticut Clerk Jones
> 3 145 Vermont Nurse Jones
> 4 202 Indiana Student Jones
> 5 101 Massachusetts Store Keeper Lee
> 6 24 Maine Accountant Smith
> The above table is sorted on column D.
>
> If , for example, I used the following formula on the above table:
> =vlookup( 120,A1:D6,4,false)
> the formula would return the name “Jones” found in cell D2
>
> Question: Is there someway that, after using the above vlookup
> formula,
> (1) To test to see if there are additional entries with the same name
> as returned by the vlookup formula and
> (2) For each same name entry, show the information in column C.
>
>

[Tom Ogilvy]

Why not use an Advanced Filter. (Data=>Filter=>Advanced Filter)

--
Regards,
Tom Ogilvy

"nebb" <[email protected]> wrote in message
news:[email protected]...
>
> _[U]Example_Table[/U_]
> A B C D
> 1 83 Vermont Doctor Doe
> 2 120 Connecticut Clerk Jones
> 3 145 Vermont Nurse Jones
> 4 202 Indiana Student Jones
> 5 101 Massachusetts Store Keeper Lee
> 6 24 Maine Accountant Smith
> The above table is sorted on column D.
>
> If , for example, I used the following formula on the above table:
> =vlookup( 120,A1:D6,4,false)
> the formula would return the name "Jones" found in cell D2
>
> Question: Is there someway that, after using the above vlookup
> formula,
> (1) To test to see if there are additional entries with the same name
> as returned by the vlookup formula and
> (2) For each same name entry, show the information in column C.
>
>
> --
> nebb
> ------------------------------------------------------------------------
> nebb's Profile:
http://www.excelforum.com/member.php...fo&userid=8981
> View this thread: http://www.excelforum.com/showthread...hreadid=384193
>

[Tom Ogilvy]

Why not use an Advanced Filter. (Data=>Filter=>Advanced Filter)

--
Regards,
Tom Ogilvy

"nebb" <[email protected]> wrote in message
news:[email protected]...
>
> _[U]Example_Table[/U_]
> A B C D
> 1 83 Vermont Doctor Doe
> 2 120 Connecticut Clerk Jones
> 3 145 Vermont Nurse Jones
> 4 202 Indiana Student Jones
> 5 101 Massachusetts Store Keeper Lee
> 6 24 Maine Accountant Smith
> The above table is sorted on column D.
>
> If , for example, I used the following formula on the above table:
> =vlookup( 120,A1:D6,4,false)
> the formula would return the name "Jones" found in cell D2
>
> Question: Is there someway that, after using the above vlookup
> formula,
> (1) To test to see if there are additional entries with the same name
> as returned by the vlookup formula and
> (2) For each same name entry, show the information in column C.
>
>
> --
> nebb
> ------------------------------------------------------------------------
> nebb's Profile:
http://www.excelforum.com/member.php...fo&userid=8981
> View this thread: http://www.excelforum.com/showthread...hreadid=384193
>

[Alan Beban]

=INDEX($C$1:$C$6,SMALL(IF($D$1:$D$6=VLOOKUP(120,$A$1:$D$6,4),ROW($D$1:$D$6)),ROW(A1)))

aray entered and filled down.

Alan Beban

nebb wrote:
> _[U]Example_Table[/U_]
> A B C D
> 1 83 Vermont Doctor Doe
> 2 120 Connecticut Clerk Jones
> 3 145 Vermont Nurse Jones
> 4 202 Indiana Student Jones
> 5 101 Massachusetts Store Keeper Lee
> 6 24 Maine Accountant Smith
> The above table is sorted on column D.
>
> If , for example, I used the following formula on the above table:
> =vlookup( 120,A1:D6,4,false)
> the formula would return the name “Jones” found in cell D2
>
> Question: Is there someway that, after using the above vlookup
> formula,
> (1) To test to see if there are additional entries with the same name
> as returned by the vlookup formula and
> (2) For each same name entry, show the information in column C.
>
>

[Tom Ogilvy]

Why not use an Advanced Filter. (Data=>Filter=>Advanced Filter)

--
Regards,
Tom Ogilvy

"nebb" <[email protected]> wrote in message
news:[email protected]...
>
> _[U]Example_Table[/U_]
> A B C D
> 1 83 Vermont Doctor Doe
> 2 120 Connecticut Clerk Jones
> 3 145 Vermont Nurse Jones
> 4 202 Indiana Student Jones
> 5 101 Massachusetts Store Keeper Lee
> 6 24 Maine Accountant Smith
> The above table is sorted on column D.
>
> If , for example, I used the following formula on the above table:
> =vlookup( 120,A1:D6,4,false)
> the formula would return the name "Jones" found in cell D2
>
> Question: Is there someway that, after using the above vlookup
> formula,
> (1) To test to see if there are additional entries with the same name
> as returned by the vlookup formula and
> (2) For each same name entry, show the information in column C.
>
>
> --
> nebb
> ------------------------------------------------------------------------
> nebb's Profile:
http://www.excelforum.com/member.php...fo&userid=8981
> View this thread: http://www.excelforum.com/showthread...hreadid=384193
>

[Alan Beban]

=INDEX($C$1:$C$6,SMALL(IF($D$1:$D$6=VLOOKUP(120,$A$1:$D$6,4),ROW($D$1:$D$6)),ROW(A1)))

aray entered and filled down.

Alan Beban

nebb wrote:
> _[U]Example_Table[/U_]
> A B C D
> 1 83 Vermont Doctor Doe
> 2 120 Connecticut Clerk Jones
> 3 145 Vermont Nurse Jones
> 4 202 Indiana Student Jones
> 5 101 Massachusetts Store Keeper Lee
> 6 24 Maine Accountant Smith
> The above table is sorted on column D.
>
> If , for example, I used the following formula on the above table:
> =vlookup( 120,A1:D6,4,false)
> the formula would return the name “Jones” found in cell D2
>
> Question: Is there someway that, after using the above vlookup
> formula,
> (1) To test to see if there are additional entries with the same name
> as returned by the vlookup formula and
> (2) For each same name entry, show the information in column C.
>
>

[Tom Ogilvy]

Why not use an Advanced Filter. (Data=>Filter=>Advanced Filter)

--
Regards,
Tom Ogilvy

"nebb" <[email protected]> wrote in message
news:[email protected]...
>
> _[U]Example_Table[/U_]
> A B C D
> 1 83 Vermont Doctor Doe
> 2 120 Connecticut Clerk Jones
> 3 145 Vermont Nurse Jones
> 4 202 Indiana Student Jones
> 5 101 Massachusetts Store Keeper Lee
> 6 24 Maine Accountant Smith
> The above table is sorted on column D.
>
> If , for example, I used the following formula on the above table:
> =vlookup( 120,A1:D6,4,false)
> the formula would return the name "Jones" found in cell D2
>
> Question: Is there someway that, after using the above vlookup
> formula,
> (1) To test to see if there are additional entries with the same name
> as returned by the vlookup formula and
> (2) For each same name entry, show the information in column C.
>
>
> --
> nebb
> ------------------------------------------------------------------------
> nebb's Profile:
http://www.excelforum.com/member.php...fo&userid=8981
> View this thread: http://www.excelforum.com/showthread...hreadid=384193
>

[Alan Beban]

=INDEX($C$1:$C$6,SMALL(IF($D$1:$D$6=VLOOKUP(120,$A$1:$D$6,4),ROW($D$1:$D$6)),ROW(A1)))

aray entered and filled down.

Alan Beban

nebb wrote:
> _[U]Example_Table[/U_]
> A B C D
> 1 83 Vermont Doctor Doe
> 2 120 Connecticut Clerk Jones
> 3 145 Vermont Nurse Jones
> 4 202 Indiana Student Jones
> 5 101 Massachusetts Store Keeper Lee
> 6 24 Maine Accountant Smith
> The above table is sorted on column D.
>
> If , for example, I used the following formula on the above table:
> =vlookup( 120,A1:D6,4,false)
> the formula would return the name “Jones” found in cell D2
>
> Question: Is there someway that, after using the above vlookup
> formula,
> (1) To test to see if there are additional entries with the same name
> as returned by the vlookup formula and
> (2) For each same name entry, show the information in column C.
>
>

[Alan Beban]

=INDEX($C$1:$C$6,SMALL(IF($D$1:$D$6=VLOOKUP(120,$A$1:$D$6,4),ROW($D$1:$D$6)),ROW(A1)))

aray entered and filled down.

Alan Beban

nebb wrote:
> _[U]Example_Table[/U_]
> A B C D
> 1 83 Vermont Doctor Doe
> 2 120 Connecticut Clerk Jones
> 3 145 Vermont Nurse Jones
> 4 202 Indiana Student Jones
> 5 101 Massachusetts Store Keeper Lee
> 6 24 Maine Accountant Smith
> The above table is sorted on column D.
>
> If , for example, I used the following formula on the above table:
> =vlookup( 120,A1:D6,4,false)
> the formula would return the name “Jones” found in cell D2
>
> Question: Is there someway that, after using the above vlookup
> formula,
> (1) To test to see if there are additional entries with the same name
> as returned by the vlookup formula and
> (2) For each same name entry, show the information in column C.
>
>

[Tom Ogilvy]

Why not use an Advanced Filter. (Data=>Filter=>Advanced Filter)

--
Regards,
Tom Ogilvy

"nebb" <[email protected]> wrote in message
news:[email protected]...
>
> _[U]Example_Table[/U_]
> A B C D
> 1 83 Vermont Doctor Doe
> 2 120 Connecticut Clerk Jones
> 3 145 Vermont Nurse Jones
> 4 202 Indiana Student Jones
> 5 101 Massachusetts Store Keeper Lee
> 6 24 Maine Accountant Smith
> The above table is sorted on column D.
>
> If , for example, I used the following formula on the above table:
> =vlookup( 120,A1:D6,4,false)
> the formula would return the name "Jones" found in cell D2
>
> Question: Is there someway that, after using the above vlookup
> formula,
> (1) To test to see if there are additional entries with the same name
> as returned by the vlookup formula and
> (2) For each same name entry, show the information in column C.
>
>
> --
> nebb
> ------------------------------------------------------------------------
> nebb's Profile:
http://www.excelforum.com/member.php...fo&userid=8981
> View this thread: http://www.excelforum.com/showthread...hreadid=384193
>

[Tom Ogilvy]

Why not use an Advanced Filter. (Data=>Filter=>Advanced Filter)

--
Regards,
Tom Ogilvy

"nebb" <[email protected]> wrote in message
news:[email protected]...
>
> _[U]Example_Table[/U_]
> A B C D
> 1 83 Vermont Doctor Doe
> 2 120 Connecticut Clerk Jones
> 3 145 Vermont Nurse Jones
> 4 202 Indiana Student Jones
> 5 101 Massachusetts Store Keeper Lee
> 6 24 Maine Accountant Smith
> The above table is sorted on column D.
>
> If , for example, I used the following formula on the above table:
> =vlookup( 120,A1:D6,4,false)
> the formula would return the name "Jones" found in cell D2
>
> Question: Is there someway that, after using the above vlookup
> formula,
> (1) To test to see if there are additional entries with the same name
> as returned by the vlookup formula and
> (2) For each same name entry, show the information in column C.
>
>
> --
> nebb
> ------------------------------------------------------------------------
> nebb's Profile:
http://www.excelforum.com/member.php...fo&userid=8981
> View this thread: http://www.excelforum.com/showthread...hreadid=384193
>

[Alan Beban]

=INDEX($C$1:$C$6,SMALL(IF($D$1:$D$6=VLOOKUP(120,$A$1:$D$6,4),ROW($D$1:$D$6)),ROW(A1)))

aray entered and filled down.

Alan Beban

nebb wrote:
> _[U]Example_Table[/U_]
> A B C D
> 1 83 Vermont Doctor Doe
> 2 120 Connecticut Clerk Jones
> 3 145 Vermont Nurse Jones
> 4 202 Indiana Student Jones
> 5 101 Massachusetts Store Keeper Lee
> 6 24 Maine Accountant Smith
> The above table is sorted on column D.
>
> If , for example, I used the following formula on the above table:
> =vlookup( 120,A1:D6,4,false)
> the formula would return the name “Jones” found in cell D2
>
> Question: Is there someway that, after using the above vlookup
> formula,
> (1) To test to see if there are additional entries with the same name
> as returned by the vlookup formula and
> (2) For each same name entry, show the information in column C.
>
>

[Tom Ogilvy]

Why not use an Advanced Filter. (Data=>Filter=>Advanced Filter)

--
Regards,
Tom Ogilvy

"nebb" <[email protected]> wrote in message
news:[email protected]...
>
> _[U]Example_Table[/U_]
> A B C D
> 1 83 Vermont Doctor Doe
> 2 120 Connecticut Clerk Jones
> 3 145 Vermont Nurse Jones
> 4 202 Indiana Student Jones
> 5 101 Massachusetts Store Keeper Lee
> 6 24 Maine Accountant Smith
> The above table is sorted on column D.
>
> If , for example, I used the following formula on the above table:
> =vlookup( 120,A1:D6,4,false)
> the formula would return the name "Jones" found in cell D2
>
> Question: Is there someway that, after using the above vlookup
> formula,
> (1) To test to see if there are additional entries with the same name
> as returned by the vlookup formula and
> (2) For each same name entry, show the information in column C.
>
>
> --
> nebb
> ------------------------------------------------------------------------
> nebb's Profile:
http://www.excelforum.com/member.php...fo&userid=8981
> View this thread: http://www.excelforum.com/showthread...hreadid=384193
>

[Alan Beban]

=INDEX($C$1:$C$6,SMALL(IF($D$1:$D$6=VLOOKUP(120,$A$1:$D$6,4),ROW($D$1:$D$6)),ROW(A1)))

aray entered and filled down.

Alan Beban

nebb wrote:
> _[U]Example_Table[/U_]
> A B C D
> 1 83 Vermont Doctor Doe
> 2 120 Connecticut Clerk Jones
> 3 145 Vermont Nurse Jones
> 4 202 Indiana Student Jones
> 5 101 Massachusetts Store Keeper Lee
> 6 24 Maine Accountant Smith
> The above table is sorted on column D.
>
> If , for example, I used the following formula on the above table:
> =vlookup( 120,A1:D6,4,false)
> the formula would return the name “Jones” found in cell D2
>
> Question: Is there someway that, after using the above vlookup
> formula,
> (1) To test to see if there are additional entries with the same name
> as returned by the vlookup formula and
> (2) For each same name entry, show the information in column C.
>
>

[Tom Ogilvy]

Why not use an Advanced Filter. (Data=>Filter=>Advanced Filter)

--
Regards,
Tom Ogilvy

"nebb" <[email protected]> wrote in message
news:[email protected]...
>
> _[U]Example_Table[/U_]
> A B C D
> 1 83 Vermont Doctor Doe
> 2 120 Connecticut Clerk Jones
> 3 145 Vermont Nurse Jones
> 4 202 Indiana Student Jones
> 5 101 Massachusetts Store Keeper Lee
> 6 24 Maine Accountant Smith
> The above table is sorted on column D.
>
> If , for example, I used the following formula on the above table:
> =vlookup( 120,A1:D6,4,false)
> the formula would return the name "Jones" found in cell D2
>
> Question: Is there someway that, after using the above vlookup
> formula,
> (1) To test to see if there are additional entries with the same name
> as returned by the vlookup formula and
> (2) For each same name entry, show the information in column C.
>
>
> --
> nebb
> ------------------------------------------------------------------------
> nebb's Profile:
http://www.excelforum.com/member.php...fo&userid=8981
> View this thread: http://www.excelforum.com/showthread...hreadid=384193
>

[Alan Beban]

=INDEX($C$1:$C$6,SMALL(IF($D$1:$D$6=VLOOKUP(120,$A$1:$D$6,4),ROW($D$1:$D$6)),ROW(A1)))

aray entered and filled down.

Alan Beban

nebb wrote:
> _[U]Example_Table[/U_]
> A B C D
> 1 83 Vermont Doctor Doe
> 2 120 Connecticut Clerk Jones
> 3 145 Vermont Nurse Jones
> 4 202 Indiana Student Jones
> 5 101 Massachusetts Store Keeper Lee
> 6 24 Maine Accountant Smith
> The above table is sorted on column D.
>
> If , for example, I used the following formula on the above table:
> =vlookup( 120,A1:D6,4,false)
> the formula would return the name “Jones” found in cell D2
>
> Question: Is there someway that, after using the above vlookup
> formula,
> (1) To test to see if there are additional entries with the same name
> as returned by the vlookup formula and
> (2) For each same name entry, show the information in column C.
>
>

[Tom Ogilvy]

Why not use an Advanced Filter. (Data=>Filter=>Advanced Filter)

--
Regards,
Tom Ogilvy

"nebb" <[email protected]> wrote in message
news:[email protected]...
>
> _[U]Example_Table[/U_]
> A B C D
> 1 83 Vermont Doctor Doe
> 2 120 Connecticut Clerk Jones
> 3 145 Vermont Nurse Jones
> 4 202 Indiana Student Jones
> 5 101 Massachusetts Store Keeper Lee
> 6 24 Maine Accountant Smith
> The above table is sorted on column D.
>
> If , for example, I used the following formula on the above table:
> =vlookup( 120,A1:D6,4,false)
> the formula would return the name "Jones" found in cell D2
>
> Question: Is there someway that, after using the above vlookup
> formula,
> (1) To test to see if there are additional entries with the same name
> as returned by the vlookup formula and
> (2) For each same name entry, show the information in column C.
>
>
> --
> nebb
> ------------------------------------------------------------------------
> nebb's Profile:
http://www.excelforum.com/member.php...fo&userid=8981
> View this thread: http://www.excelforum.com/showthread...hreadid=384193
>

[Alan Beban]

=INDEX($C$1:$C$6,SMALL(IF($D$1:$D$6=VLOOKUP(120,$A$1:$D$6,4),ROW($D$1:$D$6)),ROW(A1)))

aray entered and filled down.

Alan Beban

nebb wrote:
> _[U]Example_Table[/U_]
> A B C D
> 1 83 Vermont Doctor Doe
> 2 120 Connecticut Clerk Jones
> 3 145 Vermont Nurse Jones
> 4 202 Indiana Student Jones
> 5 101 Massachusetts Store Keeper Lee
> 6 24 Maine Accountant Smith
> The above table is sorted on column D.
>
> If , for example, I used the following formula on the above table:
> =vlookup( 120,A1:D6,4,false)
> the formula would return the name “Jones” found in cell D2
>
> Question: Is there someway that, after using the above vlookup
> formula,
> (1) To test to see if there are additional entries with the same name
> as returned by the vlookup formula and
> (2) For each same name entry, show the information in column C.
>
>