Make each cell in a column update from the same row of another sheet?

by Benjamin Cook   Last Updated December 27, 2017 02:03 AM

I'm looking for a function I could apply to a column that would make each cell in the column check the value of the first cell in its row and the first cell in its column and then return a value from the same cell of another sheet (matching first-cell-of-row + first-cell-of-column values).

For instance: • In sheet #1 the value of cell "B5" is "purple"; the value of the first cell in column "B" is "red"; the value of the first cell in row "5" is "blue". • In sheet #2, the value of the first cell in column "B" is "red"; the value of the first cell in row "3" is blue"; I'd like a function to make cell "B3" return the value "purple" automatically—except I'd like to apply this function to the entire column

Is this possible? If you have any questions about my example or my question, please ask and I'll try to clarify. Thanks!



Related Questions


How to left align dollar symbol but right align number?

Updated February 16, 2018 18:03 PM



Conditional Formatting COUNTIFS (Google Sheets)

Updated August 13, 2018 02:03 AM