Special Vlookup

[mbendit]

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.

 

[mbendit]

You can do it without the helper column like

=VLOOKUP(LEFT(A2,4)&"*",'[DV COA 12.1.20.xlsx]Sheet1'!$C:$C,1)

YOU ARE AWESOME!!! Thank you so much for not giving up on me!!!

 

[Fluff]

You're welcome & thanks for the feedback.