=IF($B2="","No EIN to Match", INDEX(business,MATCH($B2,EIN,0)))

At first this formula worked fine and then it just kept have more and more
problems
what is wrong?
Column A2:A34 has the above formula. Column B2:B34 is EINs (employer
Identification Numbers.

A38:A70 has a header "Business Name"
B38:B70 has a header "EIN"

Column A                    Column B                  Column C
Column D
A2:A34                        B2:B34                       C2:C34
D2:D34
Business name               Employer                     Taxpayer
Electronic transfer number (EFT)
                                    Identification                  Type
Number
                                    Number

Column A                      Column B
Business Name                 EIN

I copy from another program that has Employer Identification Numbers (EIN)
and other information into Column B2:B34 and it paste across the sheet then
column B2:B34 is to take the number that is in its column B and look lower
in column B in a Name Range called EIN (B38:B70) and the look left to Column
A (A38:A70) for the business name which is in a Named Range business. then
take the business name and transfer it up to column A (A2:A34).

when I transfer the information into the excel sheet it is to give me the
name without me manually comparing EINs to find the Business name. then I
take this information and copy some of it onto sheet 2 and then take that
information and paste it in word with label merge (sub part of mail merge)
and then print the labels.

Gary Reger