Jul 06 2021 06:28 AM
Is it possible to write a formula that basically matches info in 4 cells and moves info from a 5th to a new location? Something like this: if cell a and cell b equal cell h and cell I then move cell j to cell d
Jul 06 2021 07:07 AM
Your question is too vague/general. Please provide detailed information, preferable with a sample workbook.
Jul 06 2021 07:11 AM
Jul 06 2021 07:25 AM - edited Jul 06 2021 08:01 AM
In C2:
=IFERROR(INDEX($J$2:$J$1000, MATCH(1, INDEX(($H$2:$H$1000=A2)*($I$2:$I$1000=B2), ), 0)), "")
Adjust the ranges if needed.
Fill down.
Jul 06 2021 07:45 AM
Jul 06 2021 08:02 AM
SolutionMy apologies, I misplaced a parenthesis. I have corrected my previous reply to
=IFERROR(INDEX($J$2:$J$1000, MATCH(1, INDEX(($H$2:$H$1000=A2)*($I$2:$I$1000=B2), ), 0)), "")
Jul 06 2021 08:02 AM
SolutionMy apologies, I misplaced a parenthesis. I have corrected my previous reply to
=IFERROR(INDEX($J$2:$J$1000, MATCH(1, INDEX(($H$2:$H$1000=A2)*($I$2:$I$1000=B2), ), 0)), "")