Hi Folks,

I have two workbooks (wb1, wb2). wb1 looks like this

A B
2 CAT1
cust1
cust2...
5 CAT2
custA
custB...
12 CAT3
cust1a
cust1b...

wb2 looks like...

A B C D
2 849 cust1 2849
2 341 cust2 2341
5 89 custA 589
5 93 custB 593
12 91 cust1a 1291
12 429 cust1b 12429

I'm trying to get values from wb2 col D into wb1 colA (in blank cells),
where the match is the CAT value in wb1 col A and the first ten charactors in
wb1 col B.

the result I am looking for in wb1 is...

A B
2 CAT1
2849 cust1
2341 cust2...
5 CAT2
589 custA
593 custB...
12 CAT3
1291 cust1a
12429 cust1b...

I have no idea how to accomplish this. PELASE HELP!!!!!