Declamatory
Active Member
- Joined
- Nov 6, 2014
- Messages
- 319
I understand what this formula does in that it works like a VLOOKUP without the array. But I don't understand what each of the functions are doing and how it works.
I've used this formula in a number of my workbooks but don't like not understanding.
If somebody could explain it to me I would be grateful.
Thanks
I've used this formula in a number of my workbooks but don't like not understanding.
If somebody could explain it to me I would be grateful.
Thanks
Code:
=INDEX(Citi!$G$2:$G$30,SUMPRODUCT((Citi!$K$2:$K$30=J19)*ROW(Citi!$K$2:$K$30))-1)