How to change the row references in a formula when copied

Pecoflyer · #1 08-21-2024, 06:32 AM

In C16 enter relative referencing

Code:

=XLOOKUP($B16,$B6:$B11,$F6:$F11,"")

and pull down to C20.
Select B15:F22
- Copy
- Go to the desired place (e.g. B25)

- Paste Special
- Formulas
- OK

FYI OFFSET is a volatile function

Marcia · #2 08-21-2024, 07:17 AM

Quote:

Originally Posted by Pecoflyer

In C16 enter relative referencing

Code:

=XLOOKUP($B16,$B6:$B11,$F6:$F11,"")

and pull down to C20.
Select B15:F22
- Copy
- Go to the desired place (e.g. B25)
- Paste Special
- Formulas
- OK

FYI OFFSET is a volatile function

Thank you. This is exactly what I am looking for.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copied Sheet adds to formula?	ShankedS	Excel	4	10-28-2017 05:52 AM
Excel Office 365 Mac - Colour Change after copied to Workbook	Kenlyn	Excel	0	03-30-2017 04:15 AM
Cell Ref does not automatically change when formula is copied because of data orientation	Kristinmc	Excel	4	08-01-2016 10:57 AM
formula lost when copied between files	sandsoppa	Excel	2	02-14-2012 10:38 AM
Formula not getting copied to entire column	theacegary	Excel	1	11-29-2010 02:18 PM