HLOOKUP function for subtable


Hi, I have a subtable in my details view, I need to get the last value on a particular column within the given range, just like the hlookup function in Excel.

Example on the image attached:
I need a formula to get the last value on a particular column.
Ex. 4th Quarter for year 2017 = 51,469.72

Please help…Thank you very much.

Racquel E.


From your example, it sounds more like you need a function like Excel MAXIFS, however, this is not supported yet on Ragic. Can you confirm if this type of formula support is what you’re looking for? If it is, we can add it to our future enhancement list.