It looks like you're new here. If you want to get involved, click one of these buttons!
I have imported columns from several spreadsheets and different tabs using the query formula to one column in my master sheet. Now I need a formula that will fill in a different column with specific strings depending on where the cell in the first column came from. I was wondering if an If-Then statement can be applied, maybe the exception would be related to the key and also the location (the tab) of the source of the first column?
Any help is very much appreciated!