richard1234567891011
Board Regular
- Joined
- Feb 21, 2018
- Messages
- 91
Please guys I need your help with this formula. I don't know how to solve it.
The issue is that: I am using this formula:
If(ISNUMBER(FIND$F93;H1);$G93;0)
The problem is that this formula is used in a long line, changing the H1. H1=0, I1=1, J1=2, K1=3 and so on until 120.
So, the issue is: If in F93 there is for example 10, the formula will put the result (G93) not only for the cell R1 (R1=10) like I want, but for all the first line that has 10 inside. So, for 10, 100, 101, 102,103, 104,105, 106, 107, 108, 109, 110.
In conclusion I would like a formula like this that read only a number (the number in F93) and not also other number in witch the number in F93 is inside.
I don't know if it is clear, I hope.
The issue is that: I am using this formula:
If(ISNUMBER(FIND$F93;H1);$G93;0)
The problem is that this formula is used in a long line, changing the H1. H1=0, I1=1, J1=2, K1=3 and so on until 120.
So, the issue is: If in F93 there is for example 10, the formula will put the result (G93) not only for the cell R1 (R1=10) like I want, but for all the first line that has 10 inside. So, for 10, 100, 101, 102,103, 104,105, 106, 107, 108, 109, 110.
In conclusion I would like a formula like this that read only a number (the number in F93) and not also other number in witch the number in F93 is inside.
I don't know if it is clear, I hope.
