Have you considered using an INDEX/MATCH array formula?

Sheet1

A B C 1 A B 10 2 B D 20 3 R T 50 4 5 Result 6 Lookup BD 20

Spreadsheet Formulas

Cell Formula C6 {=INDEX(C1:C3,MATCH(B6,SUBSTITUTE(A1:A3&B1:B3," ",""),0))}

Confirm it with Ctrl-Shift-Enter.

## Like this thread? Share it with others