lookup function

daryl86541

Hi Iam looking to replicate the below lookup function in excel to get the last number filled out in a column range

=LOOKUP(2;1/(M11:M23<>"");M11:M23)

However this does not work in smartsheet

 

Andrée Starå

Hi Daryl,

You'd use a VLOOKUP function or an INDEX/MATCH combination instead.

More info:

https://help.smartsheet.com/function/vlookup 

https://help.smartsheet.com/function/index

https://help.smartsheet.com/function/match

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

Depending on how the setup of the sheet(s), even an INDEX/COUNT(IFS) could work if you're looking down a single column.