The true/false aspect of the vlookup is giving me some problems. I'd like the lookup to return values based off the first 4 characters in the cell while still returning the entirety of the characters in the cell of the column that I'm referencing. So, in the example below, in my spreadsheet (an upload from a payroll provider) I only have 1295. I'd like the vlookup to return the entire account number 1295-UNBILLED RECEIVABLES.
EX:
any help would be appreciated.
EX:
any help would be appreciated.