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.

 

[Fluff]

You can use Vlookup with wild cards

=vlookup(C2&"*",A2:A1000,1,0)

 

[mbendit]

You can use Vlookup with wild cards

=vlookup(C2&"*",A2:A1000,1,0)

Thank you Fluff. Can you expound a little on the wildcard please?

 

[Fluff]

With the example I used it will the 1st value in col A that starts with the contents of C2.

 

[mbendit]

With the example I used it will the 1st value in col A that starts with the contents of C2.

lol im just not getting it...

 

[Fluff]

+Fluff v2.xlsm
	A	B	C	D
1
2	1295-abc		1295	1295-abc
3	1296-abc		1298	1298-abc
4	1297-abc
5	1298-abc
6
Main

Cell Formulas
Range	Formula
D2	D2	=VLOOKUP(C2&"*",A2:A1000,1,0)
D3	D3	=VLOOKUP(C3&"*",A2:A1000,1,0)

 

[mbendit]

+Fluff v2.xlsm
	A	B	C	D
1
2	1295-abc		1295	1295-abc
3	1296-abc		1298	1298-abc
4	1297-abc
5	1298-abc
6
Main

Cell Formulas
Range	Formula
D2	D2	=VLOOKUP(C2&"*",A2:A1000,1,0)
D3	D3	=VLOOKUP(C3&"*",A2:A1000,1,0)

here is the formula i used

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

Here are the values it returned, I'm off somehow:

 

[Fluff]

You have missed the last argument, so it's doing an approximate match.

 

[mbendit]

You have missed the last argument, so it's doing an approximate match.

when i leave in the last argument it returns no values.
=VLOOKUP(A:A&"*",'[DV COA 12.1.20.xlsx]Sheet1'!$C:$C,1,0)

 

[Fluff]

do you have any values that start with 3034-00?