using a partial cell match

[kaitewright]

Hi All,

Wondering if there is a way that i can run a match - or almost like a Vlookup, i have the columns as below

Worksheet1:
A B C
Client Code Client Description Project Number
GEN General 0000

Worksheet2:
A B C
Client Task Number Task Description
0000-01-001 General Things

and i want to be able to search the worksheet2 column b to return the client code beside the tasks where the first four digits of the task numbers are the project number? So i want to match the first four digits of a task number and print the corresponding client code to the task. (Don't know if that makes much sense). If not let me know.

Cheers, Thank you!!

[Special-K]

Try this

On Worksheet 1 insert a column before column A and enter the formula
=TEXT(D1,"0") and copy it all the way down

Then in worksheet 2 enter at cell D2 enter

=VLOOKUP(LEFT(Worksheet2!A2,4)Worksheet1!A2:C65535,2)

That should work, if it does you might want to copy the formula all the way down the D column on Worksheet 2