Hi All, need help in creating a logic for excel as part of overall workflow.
I need to run Logic to lookup the correct String based on the value in column CAN in first tab, and then replace values in the string based on the FY and OBJ.
I have an excel data which contains two tabs Final Data Extract and String. I need to get correct value of string from column Concatenated Segment under tab String comparing value from column CAN which exist in both sheets. Then two things need to be change in String values mapping FY and Object Class columns in Final Data Extract tab.
Once the correct string value is taken, need to add correct FY and OBJECT class in string vallue mapping from this two columns.
Then bot will use that updated string in later process.
I have attached Excel file.
Any help will highly appreciated.
Thank you112519_FY20_CAN_Extract_UFMS.xlsx (1.5 MB)