Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2016-11-21
2
Medium Priority
?
38 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 35

Accepted Solution

by:
Norie earned 2000 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

916 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