obtaining data in text form from a table
Vlookup should do what you want, as in:
=vlookup(a2,Table,2,false)
Adjust the ranges to suit.
Regards,
Fred
"Chau" wrote in message
...
Hi all,
I like to be able to obtain the dates in a text format from the table
below. ie
Test2 8-Feb
Test5 4-Feb,8-Feb
Test6 4-Feb,5-Feb, 9-Feb
Do I need to do this by macros and if so, any help would be appreciated.
Table
Care Recipient Surname 4-Feb 5-Feb 8-Feb 9-Feb
Test1
Test2 8-Feb
Test3
Test4
Test5 4-Feb 8-Feb
Test6 4-Feb 5-Feb 9-Feb
|