vlookup??

C

cutsygurl

I'm not sure how to do this but this is what I want to do.
A B
6/27/05 262A029
6/23/05 267A042
6/24/05 267A043
6/24/05 271A001
I want to search column A for a certain date and pull out the data on
column B but some dates have multiple matches on column B. I need all
the column B data that matches the date. So in the example I
have...When I search for 6/24/05 in column A I get "267A043" and
"271A001" from column B. Can someone please help me!!!

Thanks
 
B

BenjieLop

cutsygurl said:
I'm not sure how to do this but this is what I want to do.
A B
6/27/05 262A029
6/23/05 267A042
6/24/05 267A043
6/24/05 271A001
I want to search column A for a certain date and pull out the data on
column B but some dates have multiple matches on column B. I need all
the column B data that matches the date. So in the example I
have...When I search for 6/24/05 in column A I get "267A043" and
"271A001" from column B. Can someone please help me!!!

Thanks
Click to expand...

Assuming your data range is A1:B50, try this ...

1. Enter the date in, for example, Cell C1
2. In Cell C2, enter this formula

=INDEX($B$1:$B$50,SMALL(IF($A$1:$A$50=C$1,ROW($B$1:$B$50)),ROW(1:1)))

NOTE: This is an array formula so commit with Ctrl-Shift-Enter keys.

3. Copy down this formula up to any cell where you want to stop (from
C3 to anywhere you'd like to stop on Column C).

... hope this is the formula you are looking for.

Regards.
 
Top