monsierexcel
New Member
- Joined
- Nov 19, 2018
- Messages
- 29
hey guys, i have a VBA coding problem and i am not sure if i need to write in index/match formula into my vba or if theres a better way to build this.
I have a list of numbers
<tbody>
</tbody>
SO with this table iif my value produces "6" i want it to produce test 3 - as 5 is the nearest
I think its index/match i require but not sure how to write it in VBA?
thanks guys
I have a list of numbers
<tbody> </tbody> |
<tbody>
</tbody>
SO with this table iif my value produces "6" i want it to produce test 3 - as 5 is the nearest
I think its index/match i require but not sure how to write it in VBA?
thanks guys