I'm having trouble figuring out how to populate cells based on
selecting a row. I basically have 5 columns with descriptive headers
with different values in each row. I would like to select a row and
have the 5 selected cells populate 5 main cells in another part of the
spreadsheet. Thus, of course those cell values will change everytime a
user selects a different row.
It's easy to use = and point to a particular cell (eg A3) but what if
that column letter changes all the time but the row number remains the