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.