tonkerthomas
Board Regular
- Joined
- Feb 12, 2014
- Messages
- 56
I've tried to find another thread that deals with this topic, without success, so here goes:
I have a very large block of data: thousands of rows by hundreds of columns. I need to identify a known value in that block and return the value two cells to the right of it. I can use INDEX to ascertain which row of my data the value will be in, but it could be in any column. How do I locate the value, and how do I offset my return?
Example:
<tbody>
</tbody>
I'm looking to find Clive, say, and want to return Bert. I know that Clive is in team B but I don't know where in the columns his name appears so I can't INDEX MATCH with Colhead2. I'm sure there's a way of doing this but I don't know how and an hour of Googling hasn't helped me. So, can you guys?
Thanks, as always, in advance for your help
Jeff
I have a very large block of data: thousands of rows by hundreds of columns. I need to identify a known value in that block and return the value two cells to the right of it. I can use INDEX to ascertain which row of my data the value will be in, but it could be in any column. How do I locate the value, and how do I offset my return?
Example:
Colhead1 | Colhead2 | Colhead3 | Colhead4 | Colhead5 | Colhead6 | |
TeamA | Dave | Nigel | Sarah | Ryan | Sally | Gav |
TeamB | Eric | Clive | Agnes | Bert | Dora | Rita |
TeamC | Katie | Mary | Jake | Will | Kiki | Harry |
<tbody>
</tbody>
I'm looking to find Clive, say, and want to return Bert. I know that Clive is in team B but I don't know where in the columns his name appears so I can't INDEX MATCH with Colhead2. I'm sure there's a way of doing this but I don't know how and an hour of Googling hasn't helped me. So, can you guys?
Thanks, as always, in advance for your help
Jeff
Last edited: