Uses of Match and Index

[JakeMann]

Hello,

I have the following formula-

=IFERROR(INDEX(IQC!C:C,MATCH(ROWS($C$6:$C6),IQC!$H:$H,0)),"")

The formula is looking into a sheet called 'IQC' and matching cells in another sheet. What I would like to do is match to another set of cells at the same time.

Is that possible?

Thanks

[JakeMann]

I've attached the example.

In sheet 'Deliveries' I want column G to match the figures in D6 and E6 in the 'IQC' page and return the figures in column C of the IQC page.

[bebo021999]

So you must combine Supplier & PO Number and do the match:
=INDEX(IQC!$C$1:$C$372,MATCH($B$3&E6,IQC!$D$1:$D$372&IQC!$E$1:$E$372,0))

[JakeMann]

This appears to have worked. Thank you

[Kevin UK]

Hi JakeMann

Something like the attached.

[JakeMann]

Thanks Kevin, that too is a great help

[JakeMann]

Hello,

I have a formula that partly works but am struggling to get it accurate.

On the attached spreadsheet, on page 'Deliveries', I have a list of orders and materials from the supplier stated in B6.

What I would like to do is match the material (B6) week number (D6) purchase order number (E6) against page 'IQC' columns B, C, E and return the value in column C into column G of the 'Deliveries' page.

I have an array formula that works to a point. When it gets down to B16 on the 'Deliveries' sheet it starts having trouble matching on the IQC, even though the information it needs is there.

Any ideas?