SOLVED

New Contributor

# Formula assistance

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

6 Replies

# Re: Formula assistance

Your question is too vague/general. Please provide detailed information, preferable with a sample workbook.

# Re: Formula assistance

I can not add my work book as it has too much sensitive info in it. but basically if the first and last name (column a and b) equal the same first and last name from(h and I) then I need to move the email address to column c

# Re: Formula assistance

In C2:

=IFERROR(INDEX(\$J\$2:\$J\$1000, MATCH(1, INDEX((\$H\$2:\$H\$1000=A2)*(\$I\$2:\$I\$1000=B2), ), 0)), "")

Fill down.

# Re: Formula assistance

That is close but it is only giving me the email address from cell 1000 for all
best response confirmed by Jason__Feldman (New Contributor)
Solution

# Re: Formula assistance

My 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)), "")

Thank YOU!!!