Hi there.

I have two workbooks.

In the first workbook column C has about 200 subproject names.
(Ex. C
SubProject 1
SubProject 2
SubProject 3)



In the second workbook column B there are about 400 projects
(Ex. B C
MainProject:SubProject 1 10
Mainproject:SubProject 3 5
Mainproject:SubProject 2 20)


Those 200 projects are somewhere in the 400 projects listed in the 2nd
workbook.

I need a formula in Workbook 1 Column D to look for the sameproject in
Workbook 2, column B, even though column B in workbook 2 contains more text
than Column C in workbook 1...and then put the corresponding value into
Column D Worksheet 1 in the row with the matching project.

My difficulty is making an Index Formula that uses Match...when the two
cells aren't IDENTICAL....I can use ISNUMBER...but that only gives me a True
or False...But I'm pretty sure I then need to INDEX...

Can anyone help?? :o)

Thank you so much!

You are all so smart.