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

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

Find more posts tagged with

Formulas

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

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

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