Share via

If Sheet exists

Anonymous
2021-08-26T01:31:35+00:00

How do I do the following.

In b2 I would like a formula that, If in this workbook exists a sheet with the name A1, then give me a1 from that sheet.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-08-26T03:21:24+00:00

    Hi Leiby!

    I'm Jen, and I'd be happy to help you out with this issue.

    Please enter this formula in cell B2.

    =IF(ISREF(INDIRECT("A1"&"!A1"))=TRUE,'A1'!A1,FALSE)

    I hope this information helps. If you have any questions, please let me know and I'd be glad to assist you further.

    Best Regards!

    Jen :)

    Was this answer helpful?

    0 comments