Hello,

I have some sets of data that aren't all in the same row or column. See below.

A B C D
ab 2 bg 5
ig 3 he 2
lk 1 ig 9

(Blank Row)

ab 4 op 3
fs 2 ig 5


And there's more than 2 sets as shown here. But there it does always follow that Column X is names, Column X+1 is qty. So I would like to type "ab" in say A50, and in B50 it would return 6. and "ig" would return 17. I would like to do this via formula and not have to modify or move my original data around. Thank you.