So I’m pulling a variable (let’s call it vehinfo1) from one application and need to input that data into a second application. However, the terminology/wording used in the second application is case sensitive and differs from the first application.
What I need to do is: Compare vehinfo1 variable to Column1 in a table or Excel spreadsheet and when I find a match, I need to assign the matching term from Column2 (which will always be in the same row) to a second variable (let’s call it vehinfo2) and input that into the second application.
Front FRONT END
Multiple ALL OVER
So in the above example, if vehinfo1 was compared to COLUMN1 and matched “Front” then I would need to assign vehinfo2 to “FRONT END”.
(I can very easily extract and input the variables once I have them, however I just cannot figure out how to compare and assign the values using a table or Excel spreadsheet. I’ve looked through a vast number of topics but they all have solutions for comparing or amending spreadsheets that are not relevant to my situation)