Spreadsheet: 744434d1629240294-populate-value-using-vlookup-but-from-a-string-of-text-sample
Sheet: Sheet1

UID | CID | COMP TP | HT Stat | Rule Status | [NAME] | Bot ID | NCRF Result | NCRF Status | NCRF Comments | NCRF Start | NCRF End | NC Type | Emp ID | Name | Team Lead | Date Processed | Shift
 | 199289752 | [NAME] | N 1753 | Need to Disable | 20210802_233049_venkatar | NOAMIND01RPA01-bot20pr | Need to Disable | Completed | Supplement Ordered | 2021-08-02 14:05:12 | 2021-08-02 02:05:58 |  | This cell should vlookup the text string in F2 and return the Emp Id from Ref sheet | This cell should vlookup the text string in F2 and return the Name from Ref sheet | This cell should vlookup the text string in F2 and return the Team Lead from Ref sheet | This cell should return the date the case was processed refered to column K2 | This cell should retrun the shift the case was processed in for example 08:00 AM to 05:00 PM is considered day shift and 06:00 PM to 03:00 AM the following day is night shift
 | 199289752 | [NAME] | N 1750 | Need to Disable | 20210802_233049_venkatar | NOAMIND01RPA01-bot20pr | Need to Disable | Completed | Supplement Ordered | 2021-08-02 14:05:12 | 2021-08-02 02:05:58 |  | For example F2=venkatar than emp ID=E9085 | For example F2=venkatar than emp ID=[NAME]
 | 199289752 | [NAME] | N 1742 | Need to Disable | 20210802_233049_venkatar | NOAMIND01RPA01-bot20pr | Need to Disable | Completed | Supplement Ordered | 2021-08-02 14:05:12 | 2021-08-02 02:05:58
 | 199773826 | PRINCRF | N 7624 | Need to Disable | 20210810_184902_elahabid | NOAMIND01RPA01-bot20pr | Need to Disable | Business Exception | Case status is not in RF. Check the screen shot ---> E:\RPA\UiPath\NCRP\Screenshots\NSOR-08102021091950.png | 2021-08-10 09:19:38 | 2021-08-10 09:19:51
 | 199773826 | PRINCRF | N 7615 | Need to Disable | 20210810_184902_elahabid | NOAMIND01RPA01-bot20pr | Need to Disable | Business Exception | Case status is not in RF. Check the screen shot ---> E:\RPA\UiPath\NCRP\Screenshots\NSOR-08102021091950.png | 2021-08-10 09:19:38 | 2021-08-10 09:19:51
 | 199773826 | PRINCRF | N 7608 | Need to Disable | 20210810_184902_elahabid | NOAMIND01RPA01-bot20pr | Need to Disable | Business Exception | Case status is not in RF. Check the screen shot ---> E:\RPA\UiPath\NCRP\Screenshots\NSOR-08102021091950.png | 2021-08-10 09:19:38 | 2021-08-10 09:19:51
 | 200076876 | PRINCRF | N 78461 | Order Supplement | 20210802_084337_jayakujh | NOAMIND01RPA01-bot19pr | Need to Disable | Completed | Supplement Ordered | 2021-08-01 23:54:51 | 2021-08-01 11:56:43
 | 200076876 | PRINCRF | N 78459 | Order Supplement | 20210802_084337_jayakujh | NOAMIND01RPA01-bot19pr | Need to Disable | Completed | Supplement Ordered | 2021-08-01 23:54:51 | 2021-08-01 11:56:43
 | 200076876 | PRINCRF | N 78455 | Order Supplement | 20210802_084337_jayakujh | NOAMIND01RPA01-bot19pr | Order Supplement | Completed | Supplement Ordered | 2021-08-01 23:54:51 | 2021-08-01 11:56:43
 | 200076876 | PRINCRF | N 78452 | Order Supplement | 20210802_084337_jayakujh | NOAMIND01RPA01-bot19pr | Order Supplement | Completed | Supplement Ordered | 2021-08-01 23:54:51 | 2021-08-01 11:56:43
 | 200076964 | PRINCRF | N 78508 | Order Supplement | 20210802_084337_jayakujh | NOAMIND01RPA01-bot20pr | Order Supplement | Business Exception | Case status is not in RF. Check the screen shot ---> E:\RPA\UiPath\NCRP\Screenshots\NSOR-08012021235626.png | 2021-08-01 23:56:00 | 2021-08-01 11:56:27
 | 200076964 | PRINCRF | N 78507 | Order Supplement | 20210802_084337_jayakujh | NOAMIND01RPA01-bot20pr | Order Supplement | Business Exception | Case status is not in RF. Check the screen shot ---> E:\RPA\UiPath\NCRP\Screenshots\NSOR-08012021235626.png | 2021-08-01 23:56:00 | 2021-08-01 11:56:27
 | 200076964 | PRINCRF | N 78504 | Order Supplement | 20210802_084337_jayakujh | NOAMIND01RPA01-bot20pr | Order Supplement | Business Exception | Case status is not in RF. Check the screen shot ---> E:\RPA\UiPath\NCRP\Screenshots\NSOR-08012021235626.png | 2021-08-01 23:56:00 | 2021-08-01 11:56:27
 | 200076964 | PRINCRF | N 78498 | Order Supplement | 20210802_084337_jayakujh | NOAMIND01RPA01-bot20pr | Order Supplement | Business Exception | Case status is not in RF. Check the screen shot ---> E:\RPA\UiPath\NCRP\Screenshots\NSOR-08012021235626.png | 2021-08-01 23:56:00 | 2021-08-01 11:56:27
 | 200076974 | PRINCRF | R 78499 | Need to Disable | 20210802_084337_jayakujh | NOAMIND01RPA01-bot20pr | Need to Disable | Completed | Supplement Ordered | 2021-08-01 23:56:33 | 2021-08-01 11:57:53
 | 200076974 | PRINCRF | N 78491 | Order Supplement | 20210802_084337_jayakujh | NOAMIND01RPA01-bot20pr | Order Supplement | Completed | Supplement Ordered | 2021-08-01 23:56:33 | 2021-08-01 11:57:53
 | 200076980 | PRINCRF | N 78500 | Order Supplement | 20210802_084337_jayakujh | NOAMIND01RPA01-bot26pr |  | Business Exception | Case status is not in RF. Check the screen shot ---> E:\RPA\UiPath\NCRP\Screenshots\NSOR-08022021003158.png | 2021-08-02 00:31:48 | 2021-08-02 12:31:59
 | 200076980 | PRINCRF | N 78494 | Order Supplement | 20210802_084337_jayakujh | NOAMIND01RPA01-bot26pr |  | Business Exception | Case status is not in RF. Check the screen shot ---> E:\RPA\UiPath\NCRP\Screenshots\NSOR-08022021003158.png | 2021-08-02 00:31:48 | 2021-08-02 12:31:59
 | 200076980 | PRINCRF | N 78488 | Order Supplement | 20210802_084337_jayakujh | NOAMIND01RPA01-bot26pr | Order Supplement | Business Exception | Case status is not in RF. Check the screen shot ---> E:\RPA\UiPath\NCRP\Screenshots\NSOR-08022021003158.png | 2021-08-02 00:31:48 | 2021-08-02 12:31:59