K
Khun John
Hi
I want to create a worksheet "Diary" to act as a diary planner. In worksheet
"Diary", Column A will be the date series. Diary B1 will lookup a table
($A$1:$O$500) in worksheet "Input" for the ID# (Input Column A) for any date
in Column O that matches the date in Diary A1. There may be more than one
matching date therefore each corresponding ID# would be required.
For example where Diary A1=21-07-2003 and Input O23 & O106 also =21-07-2003,
Diary B2 should return the values (ID#) of both A23 & A106 separated by a
comma (A23&","&A106).
The values in Input Column A (ID#) are in ascending order but the dates in
Input Column O are necessarily not in order; there are also date values in
some other columns between Input Column A and Input Column O.
Can anyone help?
Thanks
John
I want to create a worksheet "Diary" to act as a diary planner. In worksheet
"Diary", Column A will be the date series. Diary B1 will lookup a table
($A$1:$O$500) in worksheet "Input" for the ID# (Input Column A) for any date
in Column O that matches the date in Diary A1. There may be more than one
matching date therefore each corresponding ID# would be required.
For example where Diary A1=21-07-2003 and Input O23 & O106 also =21-07-2003,
Diary B2 should return the values (ID#) of both A23 & A106 separated by a
comma (A23&","&A106).
The values in Input Column A (ID#) are in ascending order but the dates in
Input Column O are necessarily not in order; there are also date values in
some other columns between Input Column A and Input Column O.
Can anyone help?
Thanks
John