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

Paste numbers as string

Updated November 29, 2017 02:03 AM

Stop content from making cell two lines

Updated November 30, 2017 18:03 PM

Escape parentheses around a number in Google Sheets?

Updated November 30, 2017 21:03 PM