needing Index / Match formula help, If cell matches cell in another sheet, return value from

Zdnow

Needing to populate SAP Item # is BPX MM# matches on another sheet.

jessica.smith

You could add another IF statement to return a blank ("") or 0 if the BPX MM# is blank.

=IFERROR(IF(ISBLANK([BPX MM#]@row), 0, INDEX({Source_SAP}, MATCH([BPX MM#]@row, {Source_BPX}, 0))), "")

Zdnow

genius. thanks you!

jessica.smith

@Zdnow

=IFERROR(INDEX({Source_SAP}, MATCH([BPX MM#]@row, {Source_BPX}, 0)), "")

Does this formula work for you?

Zdnow

Got it to work, thanks! Only one more challenge. Thoughts on how It could have it also return a 0 if the source MM# is blank but does have an SAP#? Currently it returns the first SAP# it finds that may not have an MM# assigned yet.

jessica.smith

You could add another IF statement to return a blank ("") or 0 if the BPX MM# is blank.

=IFERROR(IF(ISBLANK([BPX MM#]@row), 0, INDEX({Source_SAP}, MATCH([BPX MM#]@row, {Source_BPX}, 0))), "")

Zdnow

genius. thanks you!