I'm trying to figure out a function that allows me to give a description when the three specific numbers are shown in a series of text.
In my attached spreadsheet, I have 345 for cash and 567 for credit. On cell A3, I have 12345-01. So, using the given on cells A6:B7, the result for B3 is Cash.
Thanks
Bookmarks