Need help with a formula that will pull info from 2 sheets.

Shawn_K2

Hi, I have my comprehensive sheet. Its currently pulling status info from a photography sheet. When photography is done with a project (each project has its own row), the project(row) gets archived to another sheet. When achieve, the current status of the project is no longer on the comprehensive sheet.

So currently I can see the status change from the photo sheet on the comprehensive sheet. Need to be able to still see the "Complete" status when project(row) is archive.

So I'm think I need a formula that can pull from both sheets?

Current formula: =IFERROR(INDEX({Status}, MATCH([PRODUCT NAME (WF)]@row, {Title OW}, 0)), "")

How can I pull the same info, if the first sheet doesn't have it?

Paul Newcome

You would use another IFERROR/INDEX/MATCH combo.

=IFERROR(IFERROR(INDEX({Status}, MATCH([PRODUCT NAME (WF)]@row, {Title OW}, 0)), INDEX/MATCH for second sheet)), "")

Shawn_K2

Thanks Paul. I'm doing something wrong. I'm getting the #UPARSEABLE error

Here is the formula:

=IFERROR(IFERROR(INDEX({Status}, MATCH([PRODUCT NAME (WF)]@row, {Title OW}, 0)), INDEX({PHOVID STATUS}, MATCH([STYLE NUMBER (WF)],{PHOVID SKU},0))),"")

Shawn_K2

Tried it again and now I have this error: #INCORRECT ARGUMENT SET

=IFERROR(IFERROR(INDEX({Status}, MATCH([STYLE NUMBER (WF)]@row, {OW Style}, 0), INDEX({PHOVID STATUS}, MATCH([STYLE NUMBER (WF)]@row, {PHOVID SKU}, 0)))), "")

Paul Newcome

@Shawn_K2 I don't see anything right off. Are you able to provide a screenshot of the formula open in the sheet similar to the screenshot below?

Paul Newcome

@Shawn_K2 The incorrect argument formula has misplaced parenthesis.

The unparseable formula is missing "@row" after the style number reference (sorry for not catching that before my last comment).

=IFERROR(IFERROR(INDEX({Status}, MATCH([PRODUCT NAME (WF)]@row, {Title OW}, 0)), INDEX({PHOVID STATUS}, MATCH([STYLE NUMBER (WF)]@row,{PHOVID SKU},0))),"")

Shawn_K2

Paul Newcome

@Shawn_K2 Your screenshot formula has a misplaced parenthesis. Check my last comment. I think we were typing at the same time.

Shawn_K2

OMG! You are so awesome Paul!!! That worked!

Paul Newcome

Happy to help. 👍️