LOOKUP function - I cannot find any info on how it is supposed to work

Eleonora Scoseria

Hi,

I have read some threads but I am still not clear on how LOOKUP is supposed to work.

I know it cannot function across sheets.

But please can someone provide the syntax and basic data?
Thanks,
Ele

Eleonora Scoseria

I finally found this. For some reason the search function did not work).

 

https://help.smartsheet.com/articles/775363-using-formulas#lookup

Eleonora Scoseria

And I am now again with a problem....when I copy a formula, the range changes...any way to fix it?

J. Craig Williams

Smartsheet's cells allow relative or absolute references.

 

=Task23

 

is relative to row 23 in the Task column.

 

When copied to the row below it, the new formula will reference row 24.

 

=Task$23

 

would prevent that - this is an absolute reference to row 23.

Now matter where on the sheet you copy this to, the formula will refence row 23.

 

=$Task$23

 

is an absolute reference to the cell at row 23, in the Task column. When copied, the formula will still reference that cell.

 

($Task23 is also available)

 

Hope that helps.

 

Craig