Formula assistance

[Jason__Feldman]

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

[#2]

@Jason__Feldman 

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

[#3]

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

[#4]

@Jason__Feldman 

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.

[#5]

That is close but it is only giving me the email address from cell 1000 for all

[#6 · Accepted solution]

@Jason__Feldman 

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

[#7]

Thank YOU!!!