Pulling Data from another sheet

Tartaruchus77

I have two sheets with a few hundred rows filled with site information. The common data between each table is the site number.

What formula would I use in a cell if I wanted my primary smartsheet to check the other sheet for the site number on a row and return data from a different cell in that same row? All site information is on a single row.

Paul Newcome

You would use an INDEX/MATCH.

=INDEX({Column To Pull Over}, MATCH([Site Number]@row, {Site Number}, 0))

Zachary Ziegler

Sounds like this is a good use case for the VLOOKUP function! I'll list the documentation on how it works, but it can be used to reference cells from another sheet by specifying the column and the lookup table for a given value.
https://help.smartsheet.com/function/vlookup

I'll list the documentation here, but when you start to write the formula you should see a blue link similar to the one in this screenshot: