Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

If the price is always in cell F2 of the sheet named by column B then you could use the INDIRECT function for the price column.

=INDIRECT($B2 & ".F2")

Assuming this is on row 2 of your spreadsheet and you then copy this cell to the other rows of your spreadsheet for the price column.

Note. F2 does not include $ as this is in quotes as a string and will not be modified when the formula is copied to other cells.