|
|
#4
08-21-2024, 06:32 AM
|
||||
|
||||
In C16 enter relative referencing
Code:
=XLOOKUP($B16,$B6:$B11,$F6:$F11,"") Select B15:F22 - Copy - Go to the desired place (e.g. B25) - Paste Special - Formulas - OK FYI OFFSET is a volatile function
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 10 
Office 2021
Threaded Mode