Peter Davison
Active Member
- Joined
- Jun 4, 2020
- Messages
- 437
- Office Version
- 365
- Platform
- Windows
I have a one column (GP3 to GP200) which includes a number of headings and below each heading is the cell contents I want to retrieve (always 4 rows below the heading).
The selection for the heading is on a list in a separate cell (FP6) for the user to select so it needs to find the heading from Cell FP6 in the list (GP3 to GP100) then return the cell contents 4 rows below.
I'm really stuck on this I just can't get the answer right.
Any help would be appreciated.
The selection for the heading is on a list in a separate cell (FP6) for the user to select so it needs to find the heading from Cell FP6 in the list (GP3 to GP100) then return the cell contents 4 rows below.
I'm really stuck on this I just can't get the answer right.
Any help would be appreciated.