Link to other sheet cell, locked to row 1

I know how to use "Link from cell in other sheet", but what I would like to do is link to an absolute cell reference, in a particular column in row 1 at all times. This is so when I add new rows to the top, the new row 1 content in a particular column will show in a fixed cell location in another sheet. Is this possible, as I have not been able to find an answer as yet in my search? Thanks in advance!

Find more posts tagged with

absolute reference

Accepted answers

phil.hardy

Okay, I think I may have solved my question, with a bit of trial and error. What appears to be working is as follows:

=INDEX({1003 Hire Record Range 1}, 1)

The selected range is the whole column of which I want to pull the single cell value from, being always row 1 of that column. This seems to work. I tried a few other different range selections which would exclude new rows added to the sheet; if I selected complete rows in the sheet.

All comments

phil.hardy

Okay, I think I may have solved my question, with a bit of trial and error. What appears to be working is as follows:

=INDEX({1003 Hire Record Range 1}, 1)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.