=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