B
BubbleGum
Hello,
Please help me on getting the correct way to lookup a value and return
multiple corresponding values.
In sheet1 first row, I list out the dates as: 11 01 05, 11 02 05, 11 03 05
etc...
In sheet2 Column A, it is a list of account number; where as Column B is a
list of dates.
I would like to use the dates as appear in sheet1 and return the
corresponding account number. Since there are multiple account number which
match with the dates, so, vlookup cannot be used. I tried the following but
it doesn't work:
=INDEX(Sheet2!$A:$B, SMALL(IF(Sheet2!$B$2:$B$6=Sheet1!$B$1,
ROW(Sheet2!$B$2:$B$6)), ROW(1:1)),1)
Your reply is much appreciated.
Please help me on getting the correct way to lookup a value and return
multiple corresponding values.
In sheet1 first row, I list out the dates as: 11 01 05, 11 02 05, 11 03 05
etc...
In sheet2 Column A, it is a list of account number; where as Column B is a
list of dates.
I would like to use the dates as appear in sheet1 and return the
corresponding account number. Since there are multiple account number which
match with the dates, so, vlookup cannot be used. I tried the following but
it doesn't work:
=INDEX(Sheet2!$A:$B, SMALL(IF(Sheet2!$B$2:$B$6=Sheet1!$B$1,
ROW(Sheet2!$B$2:$B$6)), ROW(1:1)),1)
Your reply is much appreciated.