Solved

How do I update en Excel formula to include the woksheet name?

Posted on 2016-11-21
2
27 Views
Last Modified: 2016-11-21
I have the below formula that returns the value on cell A1 before any spaces. The below formula does the following,

IFERROR(LEFT(A1,FIND(" ",A1)-1),A1)

For example
If A1 is equal to "Retail Values" the formula returns "Retail". How can I update the formula so that it looks for A1 in Sheet 2?
0
Comment
Question by:Conernesto
2 Comments
 
LVL 33

Accepted Solution

by:
Norie earned 500 total points
ID: 41896484
Try this.

IFERROR(LEFT(Sheet2!A1,FIND(" ",Sheet2!A1)-1),Sheet2!A1)
0
 

Author Closing Comment

by:Conernesto
ID: 41896513
Thank you.
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question