Bassplayer
New Member
- Joined
- Oct 22, 2013
- Messages
- 11
I'm strugling with a problem. I can get the first correspondence in row, or the last value in a row but what I want is to get a correspondence within a table. I will give an example:
Sheet1
<tbody>
</tbody>
Sheet2
<tbody>
</tbody>
For example, if I put Contract A in 01-Jan and 05-Jan, it should appear on the table of Sheet2 the date 01-jan on the first "x" in the Contract A row (the x is just where a formula shoud be, it doesn´t have to be an X) and 05-Jan on the second X.
Is it possible to get this working like this? Thanks in advance. I´ve tried with index, vlookup etc but i´m not getting it.
Cheers
Sheet1
01-jan | 02-jan | 03-jan | 04-jan | 05-jan | 06-jan | ||
PersonA | Contract A |
<tbody> </tbody> | |||||
PersonB | Contract A | ||||||
PersonC | Contract B | ||||||
PersonB | Contract C |
<tbody>
</tbody>
Sheet2
Contract A | x | x | x | ||
Contract B | x | x | |||
Contract C | x |
<tbody>
</tbody>
For example, if I put Contract A in 01-Jan and 05-Jan, it should appear on the table of Sheet2 the date 01-jan on the first "x" in the Contract A row (the x is just where a formula shoud be, it doesn´t have to be an X) and 05-Jan on the second X.
Is it possible to get this working like this? Thanks in advance. I´ve tried with index, vlookup etc but i´m not getting it.
Cheers