Count if with partial text match (edited X2)

[nicholas.b.irwin]

Ok, this problem has been driving me nuts and I wanted to elicit some
advice from the experts. I will try to explain it the best that I can
and hopefully with a bit of illustration.

I have data spread over two different sheets. Sheet 1 looks like this
(shortened for clarity):

A B
1 leaname state4math08
2 ABSAROKEE ELEMENTARY
3 ABSAROKEE HIGH SCHOOL
4 ALBERTON K-12 SCHOOLS
5 ALDER ELEMENTARY
6 ALZADA ELEMENTARY
7 AMSTERDAM ELEMENTARY

Sheet 2 looks like this:

A B
1 Name passed
2 Absarokee Elem 0.6
3 Amsterdam Elem 0.77

My goal is to have the values of column B in Sheet 2 counted in column
B of Sheet 1 but only if the names from A2 matches the name in A2.
For clarity...the value of B2 (sheet 2) should go into B2 (sheet 1)
since A2 (sheet 2) matches A2 (sheet 1). I would then like to use the
same formula for the entire sheet.

As you have probably noticed, the texts do no match exactly. Though
they share a significant amount of letters, I can't seem to figure out
how to compensate for this.

I tried to troll around to find a suitable solution but I can't seem
to figure it out based on the help for other problems. I have an
inkling this may best be solved using VBA solution but lets see if I
can avoid that since my VB is really rusty.

Thanks in advance and let me know if I need to elaborate.

~Nic

(lets hope this thing posts correctly this time)

 

[Shane Devenshire]

Please see response on earlier post.