Jyggalag
Active Member
- Joined
- Mar 8, 2021
- Messages
- 445
- Office Version
- 365
- 2019
- Platform
- Windows
Dear all,
I am currently trying to return some data from a larger database. I have created a test sheet that is very similar to the real sheet that I am working with, for the sake of privacy and making things easier to understand from an outside perspective.
Currently, I have the following (please ignore column B, D and E and everything but cell C1 in column C.
The formula pulls data from this master data sheet, called "Test data transposed":
My issue is currently that the formula only works for the first value, I.E. cell F2. Once I pull it down to cell F8 it just leaves cells F3-F8 blank.
Can anybody help me fix this so the values in F3-F8 return the correct values?
Apologies for any confusion - please feel free to ask questions and ask me for more data or screenshots as well!
Kind regards,
Sheogorath
I am currently trying to return some data from a larger database. I have created a test sheet that is very similar to the real sheet that I am working with, for the sake of privacy and making things easier to understand from an outside perspective.
Currently, I have the following (please ignore column B, D and E and everything but cell C1 in column C.
The formula pulls data from this master data sheet, called "Test data transposed":
My issue is currently that the formula only works for the first value, I.E. cell F2. Once I pull it down to cell F8 it just leaves cells F3-F8 blank.
Can anybody help me fix this so the values in F3-F8 return the correct values?
Apologies for any confusion - please feel free to ask questions and ask me for more data or screenshots as well!
Kind regards,
Sheogorath