If one sheet is showing a name in a row how can i highlight the name on another sheet?
Answers
-
Removed, now getting error : #INVALID REF
-
@Ashley Lewis That means you have not properly created your cross sheet reference.
Start typing
=CONTAINS(
Then in the formula helper box you should see a blue hyperlink to "Reference another sheet". Click on that to open the cross sheet reference dialog box. Select the sheet you want to reference from the menu on the left, click on the column header of the column you want to reference (optionally rename the reference in the reference name section in the top left of the window), then click on the blue "Insert Reference" button in the bottom right corner.
The dialog window should disappear, and the cross sheet reference should automatically be in place.
=CONTAINS({Cross Sheet Reference Name}
Next type your comma and finish out the formula.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 433 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 505 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!