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

Options
✭✭✭

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?

Tags:

• ✭✭✭✭✭✭
Options

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

• ✭✭✭
Options

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

• ✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

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

• ✭✭✭
edited 06/14/23
Options
• ✭✭✭✭✭✭
Options

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

• ✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!