Example =ISREF(INDIRECT("'"&B3&"'!A1")) Generic Formula...
How To Test If A Sheet Exists
read more
About the Author
John MacDougall
John is a Microsoft MVP and qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. He is a keen problem solver and has a passion for using technology to make businesses more efficient.
Subscribe
Subscribe for awesome Microsoft Excel videos 😃
Articles from John MacDougall
How To Generate A Random Letter
Example =CHAR(RANDBETWEEN(B3,C3)) Generic Formula =CHAR(RANDBETWEEN(Lower,Upper)) Lower - This is an...
How To Get The Domain From An Email Address
Example =RIGHT(B3,LEN(B3)-FIND("@",B3)) Generic Formula =RIGHT(Email,LEN(Email)-FIND("@",Email)) Email -...
Get the Latest Microsoft Excel Tips
Follow Us
Follow us to stay up to date with the latest in Microsoft Excel!
Subscribe for awesome Microsoft Excel videos 😃