This app will allow you to search for and return a value from a CSV data file. You specify the target column and value (i.e. the value to find in a specific column), and the tool returns the value from the "return" colum and writes in to private data.
This is a simple lookup tool, but it's essential if you need the function. In our case, we needed to lookup an order details combination on a list of a couple hundred combinations, and then return a numerical value from the CSV file.
This tool worked perfectly, though I did have one frustrating instance (due to my own mistake) where nothing seemed to work because of an extra space I had at the end of a calculation field.
It's nice that the tool will constantly check the spreadsheet for updates, so changes can be made and pushed live without even having to do anything in Switch.
