joyofgiving
New Member
- Joined
- Nov 19, 2014
- Messages
- 2
Report with following data which has the Course ID & related info | ||||||
Course Id | Start Date | End Date | Course Type | City | State | Teacher(s) |
BC0022 | 11/15/13 | 11/19/13 | Course one | Vancouver | British Columbia | MR XYZ |
BC0002 | 3/28/13 | 3/31/13 | Art of Silence | British Columbia | MS OPQ | |
BC0021 | 11/21/13 | 11/24/13 | Course super one | Vancouver | British Columbia | MR ABC |
BC0020 | 12/18/13 | 2/21/14 | Fantastic course | Chilliwack | British Columbia | MR EFG |
ALTA84 | 4/10/14 | 4/14/14 | Art of Living Happiness Program | Calgary | Alberta | MS HIJ |
ALTA91 | 4/24/14 | 4/27/14 | Art of Living | Edmonton | Alberta | MS LMN |
I WANT TO BE ABLE TO OBTAIN THE INFO FROM THE ABOVE REPORT FOR CITY ,STATE & TEACHERS AND LOAD INTO ANOTHER SHEET , SHOWN HEREUNDER ,WHICH HAS COURSE ID INFO INCLUDED SAME AS FIRST COLUMN ABOVE BUT WITH OTHER INFO AS WELL. IS THERE ANY FORMULA OR WAY TO BE ABLE TO DO SOMETHING SIMILAR TO VLOOKUP AND GET THE CITY AND TEACHERS INFO FROM LEFT SIDE OF THE REPORT TO THE REPORT HEREUNDER ( THESE ARE TWO DIFF TABS IN ACTUAL WORKSHEET) | ||||||
S|CRS|ALTA84|10 Apr 2014|ALTA|Art of Living Happi | ||||||
S|CRS|BC0037|12 Jun 2014|BC|Art of Living Happine | ||||||
S|CRS|QUE087|19 Jun 2014|QUE|Art of Living Happin | ||||||
S|CRS|ALTA95|05 Jun 2014|ALTA|Art of Living Happi | ||||||
Doing text to data and then Vlookup is very timeconsuming and complex as the column has multiple diff types of info so want a easier way. thanks! |
<tbody>
</tbody>