obtaining data in text form from a table

C

Chau

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
 
F

Fred Smith

Vlookup should do what you want, as in:
=vlookup(a2,Table,2,false)
Adjust the ranges to suit.

Regards,
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

obtaining data from a table 1
General numbers lookup from FY-PP-WK-D resulting in MM-DD-YY 3
Search closest day in the past from today 2
Looking up values in a table 2
How to remove weekends from the chart 2
Auto copy data rows between sheets depending on date entry 3
Gathering Comments from Survey Data 3
Overcoming the restriction of 7 nested IFs in Excel XP. Is it possible? 10

Top