How do I replicate data from one cell to another cell in SAME sheet

bobbyf

How do I duplicate/replicate cell data from column A, to another column in same sheet, Column B. I know how to link cells to another sheet but not in same sheet.

Ric T

Hi @bobbyf,

Looks like an Index and Match formula is what you're after.

I found this resource very useful, highly recommend as @Brett Wyrick outlines it step-by-step.

https://community.smartsheet.com/discussion/84774/index-and-match-across-two-sheets-a-detailed-explanation

Cheers,

Ric