tonkerthomas
Board Regular
- Joined
- Feb 12, 2014
- Messages
- 56
Good morning everybody.
I have a spreadsheet which is made up of six identical, adjacent blocks of data, each of twenty columns or so. The structure of each block of data is identical. Within those six blocks of data, I need to be able to find a value (which can only appear once), and look up the value which is next to it. I feel sure this isn't that hard, but having not used Excel for a few years, and with a new version (Office 365) to work with, I'm struggling to do things which I might once have done without thinking. It's a terrible thing to get old.
Can anybody help me, please?
I have a spreadsheet which is made up of six identical, adjacent blocks of data, each of twenty columns or so. The structure of each block of data is identical. Within those six blocks of data, I need to be able to find a value (which can only appear once), and look up the value which is next to it. I feel sure this isn't that hard, but having not used Excel for a few years, and with a new version (Office 365) to work with, I'm struggling to do things which I might once have done without thinking. It's a terrible thing to get old.
Can anybody help me, please?
