Lookup Help

[Ravenousdead]

I'm hoping someone can help me with this. I'm trying to look through 2 columns at the same time while matching them to data from 2 other columns and linking data from a third.
Here is my example. I need to pull the qty from the second group to the first based on the job and operation info.

Job	Op.	Qty.		Job	Qty.	Op.
a	1			b	4	1
a	2			a	5	2
b	1			a	6	1

[Richard Buttrey]

...and what's the answer to the limited example you show? I can see no Job/Op combination from the first group in the second group.

Assuming there were to be matches, could there be many matches, implying you need to sum data rather than just getting a single value? It would help if you'd upload an actual example of real data and manually add the results you expect.

[Ravenousdead]

I fixed the second table.

[Richard Buttrey]

Hi,

Entered as an array formula (i.e.Ctrl Shift Enter) in C2 and copied down

Please Login or Register  to view this content.

[Ravenousdead]

It works. Thank you. :]

[Richard Buttrey]

Don't sound so surprised,

Glad to have helped......and thanks for the rep.