ChristianSigge
New Member
- Joined
- May 10, 2018
- Messages
- 2
Hello,
I have a problem, maybe it's simple but I'm not able to solve this,
thats how my sheet looks like:
<tbody>
</tbody>
In Cell "J" I'm using this Formula to read out a specific value:
In cell "K" I want to read out the Value next to the Name, for example in this case I'm searching for the Name "Sandro" and I want to read out the job Number next to his name.
I tried it with offset,
<countif(a:a;"sandro");offset(a:a;1;1;1;1);"")< strong=""><countif(a:a;"sandro");offset(a:a;1;1;1;1);"")< strong="">, it's not working correctly it read out the value of all listet Job numbers and not just the numbers next to the name "Sandro".
Thank you very much for your help.</countif(a:a;"sandro");offset(a:a;1;1;1;1);"")<></countif(a:a;"sandro");offset(a:a;1;1;1;1);"")<></countif(a:a;"sandro");"sandro";"")<></countif(a:a;"sandro");"sandro";"")[>
I have a problem, maybe it's simple but I'm not able to solve this,
thats how my sheet looks like:
Name | Jobnumber |
Sandro | A801336.00 |
Alex | A801233.01 |
Sandro | A802444.00 |
<tbody>
</tbody>
In Cell "J" I'm using this Formula to read out a specific value:
<countif(a:a;"sandro");"sandro";"")[ quote]<countif(a:a;"sandro");"sandro";"")[="" code]<countif(a:a;"sandro");"sandro";"")<="" strong=""><countif(a:a;"sandro");"sandro";"")< strong="">=IF(ROW(A2)-1<
COUNTIF(A:A;"Sandro");"Sandro";"")
In cell "K" I want to read out the Value next to the Name, for example in this case I'm searching for the Name "Sandro" and I want to read out the job Number next to his name.
I tried it with offset,
=IF(ROW(A2)-1<
COUNTIF(A:A;"Sandro");OFFSET(A:A;1;1;1;1);"")
<countif(a:a;"sandro");offset(a:a;1;1;1;1);"")< strong=""><countif(a:a;"sandro");offset(a:a;1;1;1;1);"")< strong="">, it's not working correctly it read out the value of all listet Job numbers and not just the numbers next to the name "Sandro".
Thank you very much for your help.</countif(a:a;"sandro");offset(a:a;1;1;1;1);"")<></countif(a:a;"sandro");offset(a:a;1;1;1;1);"")<></countif(a:a;"sandro");"sandro";"")<></countif(a:a;"sandro");"sandro";"")[>