Hello
I have formula that's working fine in small data but now I have to use in a large data set so I really need a way to optimize the formula.
the table is like this,
<tbody>
</tbody>
and When I tried to look for
Ref 1's height.
using index and match
=index([Height],match(Search Cell Number, Ref)
and I get the right one.
https://drive.google.com/open?id=1tip-jl5Y0e6LWJJIyS3B8r97hqSmz_uS
please help thanks all for reading my post
I have formula that's working fine in small data but now I have to use in a large data set so I really need a way to optimize the formula.
the table is like this,
Ref | Name | Height | Strength | Weight |
1 | A | 150 | 120 | 60 |
2 | B | 150 | 120 | 60 |
3 | C | 110 | 10 | 60 |
4 | D | 180 | 200 | 80 |
<tbody>
</tbody>
and When I tried to look for
Ref 1's height.
using index and match
=index([Height],match(Search Cell Number, Ref)
and I get the right one.
https://drive.google.com/open?id=1tip-jl5Y0e6LWJJIyS3B8r97hqSmz_uS
please help thanks all for reading my post