Feb 04 2020 06:15 AM
hi I am getting my hair off with this one, I have 3 columns
i need to type in the part number and the operation number (sheet1)and the PPH (sheet1) needs to find the correct pph on the second sheet based on the 2 factors
part number / operation / pph
1 / 10 / 1000
1 / 20 / 2000
Feb 04 2020 06:18 AM
Feb 04 2020 06:36 AM
Feb 04 2020 06:36 AM - edited Feb 04 2020 06:37 AM
Hello @STUARTMAC,
That would be something like:
{=INDEX(PPH_Range, MATCH(1, (Part_Number=Part_Number_Range)*(Operation=Operation_Range), 0))}
Refer here:
https://exceljet.net/formula/index-and-match-with-multiple-criteria
With a sample file, I could help further.
Feb 04 2020 06:55 AM