Hello,
What would be the best way to automatically generate a set text based on another text (mixed letters & numbers)?
I will use this on imported CSV files from my bank.
For example: account number XF999 (from a supermarket) will automatically generate “groceries” etcetera.
Thanks
You can create a “Reference” sheet that contains a list of all account numbers and the Category it represents. Then, in your main sheet you enter “XF999” in one column and in the next column is a formula that does a VLOOKUP to the Reference sheet, finding “XF999” and returning “groceries”
Uploading an example, with the “imported” data highlighted in green. The first column contains a formula that looks up the text belonging to the code. I copied the formula from the first cell down to the rest of the rows.
NativusExample.ods (19.6 KB)
Very cool, this is exactly what I am looking for.
Onward with my financial spreadsheet deluxe.
Your help is much appreciated!