SOLVED

Formula assistance

New Contributor

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

@Jason__Feldman 

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

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

@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.

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

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

Thank YOU!!!