Hi, maybe something like this (assuming your data starts in D2) ...

=Vlookup(Left(C2,Find(" ",C1,1)-1),A:B,2,0)

If your values in column A are numerical, you'll need to coerce your lookup
values ...

=Vlookup(0+Left(C2,Find(" ",C1,1)-1),A:B,2,0)

--
Regards,
Zack Barresse, aka firefytr

"jenhow" wrote in message
...
I have three columns of information.

column A - 6 digit number
column B - 8 digit number and dash that correspond to column A
column C - 6 digit number with other data that match one of the entries
from

column A
I would like column D to give the result from column B that corresponds to
column A based on the data from column C and if it matches (partially)
column
A.

example

A B C
D
050505 04-121212 050505 - CO.fsa (formula here)
050452 05-214176 050505 - CO.fsa
052121 03-217496 050505 - CO.fsa

In this example, I would like column D result to be 04-121212 for all
three
entries because that it the number listed in column C.


In this instance, I would like column D to return 04-121212 for all three
answers. So, I want the results from column C that go with Colum