I have a 2 worksheets:

Sheet 1:
Account No. Profit Center Group
31000 80000000
21000 40000000
30000 85000000

I want to return the Group Name from another worksheet containing wildcard
data:

GROUP Account No Profit Center
A 3*********** 8***********
B 21********** 400********

For e.g the first record in Sheet 1 to return Group A, 2nd record to return
Group B and third record to return Group A.

I try sumproduct but can only return value not text.

Please help.