如何用Excel公式直接将T1数据填充至T2？需避免=A1类公式

Got it, I get what you're asking for—you need ways to populate T2 with the value from T1 without relying on the basic =T1 cell reference. Here are four reliable, non-trivial solutions that work seamlessly in Excel:

• Using INDIRECT (Dynamic Text-Based Reference)
  The INDIRECT function resolves a text string into a cell reference. Instead of directly pointing to T1, we pass its address as a string:

  =INDIRECT("T1")
  

  This works because INDIRECT interprets the text "T1" as the actual cell location, pulling its value into T2 without a direct static reference.

• Using INDEX (Position-Based Lookup)
  INDEX lets you retrieve a value from a range by specifying its row and column position. For T1, we target column T and row 1:

  =INDEX(T:T, 1)
  

  Here, we're referencing the entire column T and asking for the value in row 1—no direct cell reference, just positional targeting.

• Using OFFSET (Relative Reference from T2)
  OFFSET creates a reference relative to a starting cell. We can start at T2 and shift up one row to reach T1:

  =OFFSET(T2, -1, 0)
  

  The -1 moves us up one row from T2, and 0 keeps us in the same column. This is a dynamic relative reference rather than a direct static link to T1.

• Using XLOOKUP (Modern Position Match)
  If you're on Excel 365 or a newer version, XLOOKUP offers a clean way to target the first row of column T:

  =XLOOKUP(ROW(T1), ROW(T:T), T:T)
  

  This matches the row number of T1 (which is 1) against all row numbers in column T, returning the corresponding value from column T. It’s a more robust modern alternative to the older functions.

All these formulas achieve your goal of pulling T1’s value into T2 without using the simple =T1 reference. Each works differently, so you can pick the one that fits your workflow best!

内容的提问来源于stack exchange，提问作者Regiz