lookup a value and return cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
Click to expand...

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
 
Biff said:
Hi!


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




Hi,
Click to expand...
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$10,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 (e-mail address removed)
 
Back
Top