Problem: I have a 4 column table. Column 1 contains the day,column 2 a name,
column 3 arrival time, column 4 departure time. For a day I can have multiple
entires.
Using VLOOKUP returns only the first entry for a certain day. Does anybody
know how to return multiple matches for a specific day?
Thanks in advance.

Hi!

Column 1 contains the day

Is that the day name like Monday, Tuesday, etc.? Is "day" a DATE like
1/1/2006? What data do want returned? From all 4 columns? From only 1
column?

Biff

"Dwarf" wrote in message
...
Problem: I have a 4 column table. Column 1 contains the day,column 2 a
name,
column 3 arrival time, column 4 departure time. For a day I can have
multiple
entires.
Using VLOOKUP returns only the first entry for a certain day. Does anybody
know how to return multiple matches for a specific day?
Thanks in advance.

"Biff" wrote:

Hi!

Column 1 contains the day

Is that the day name like Monday, Tuesday, etc.? Is "day" a DATE like
1/1/2006? What data do want returned? From all 4 columns? From only 1
column?

Biff

"Dwarf" wrote in message
...
Problem: I have a 4 column table. Column 1 contains the day,column 2 a
name,
column 3 arrival time, column 4 departure time. For a day I can have
multiple
entires.
Using VLOOKUP returns only the first entry for a certain day. Does anybody
know how to return multiple matches for a specific day?
Thanks in advance.


Hi,
Column 1 contains the day of year- a number,
According the column 1 the content of column 2 to 4 should be returned,which
are the input for a dynamic graph. The day is not unique which means it's
possible to have more entires for the same day

Hi,

I have worked on a similar problem before. Assuming your data in range
A1:B7 is set out like this:

Ashish 100
Sanjay 200
Pongal 300
Ashish 400
Rajesh 500
Suresh 600
Ashish 700


In cell A10, enter Ashish and in cell B10, array enter the following formula
(Ctrl+Shift+Enter)

IF(ISERROR(INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=$A$1 0,ROW($A$1:$A$7)),ROW(1:1)),2)),"",INDEX($A$1:$B$7 ,SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1) ),2))

Hope this helps you. If you still have any more queries, please feel free
to contact me at


"Dwarf" wrote:

Problem: I have a 4 column table. Column 1 contains the day,column 2 a name,
column 3 arrival time, column 4 departure time. For a day I can have multiple
entires.
Using VLOOKUP returns only the first entry for a certain day. Does anybody
know how to return multiple matches for a specific day?
Thanks in advance.