Formula Help

[dessie_moonsamy]

Hi All,

I created a sheet which my staff update in a month. This sheet collects data on store performance. There are instances were this sheet will contain 2 rows for a store visited in a particular month because of the store visited twice.

How do i lookup the last updated row and vlookup a particular cell?

thank you for your assistance.

Stay Blessed
Dessie

[Aleksi]

You could read the last value with the combination of LOOKUP and MAXROW expressions. Something like…
LOOKUP(MAXROW(“TableName”,"_Rownumber"),“TableName”,“KeyColumnName”,“ColumnName”)

[dessie_moonsamy]

HI Aleksi,

Need your help with this formula please. I tried to substitute my columns in the formula and i keep getting #error

Please help.

Stay Blessed
Dessie

[Aleksi]

May I ask what that formula is?

[dessie_moonsamy]

LOOKUP(MAXROW(“TableName”,"_Rownumber"),“TableName”,“KeyColumnName”,“ColumnName”)

So i have a sheet that is called “call report” and this sheet collects the data. and in this sheet i can get data on a particular store more than once.

I then have another sheet that looks up the last occurrence and brings in the value of a specific column.

LOOKUP(MAXROW(Call Report,_Rownumber),Call Report,Store,Current Month Actual)

[Aleksi]

To be sure first try to use… LOOKUP(MAXROW(“Call Report”,"_Rownumber"),“Call Report”,“Store”,“Current Month Actual”). Then… Is the “Store” column a key column?

[dessie_moonsamy]

the key column is Date. I substituted it and i still get an #error

[Aleksi]

The MAXROW expression will give you the value of that row’s key column value. Then you need to find that value from the key column with your lookup.

[dessie_moonsamy]

let me try it in steps and see the result it gives me.

Thank you Aleksi

Do you know if a column can become not editable after a save is done?

[Aleksi]

Yes it can… for many reasons. For example key column will do that or if you have some kind of formula with the option “Editable”.