I want Excel to look into the formula of a cell and then display a different cell based on that. confused yet?
Column A on sheet 1 has a size and column B on sheet 1 has a tolerance.
Could be same numbers in both column throughout. Now on sheet 2 I want to be able in column A to reference, lets say A4/1 with a simple
=sheet1!A4 that I can manually put in and then I want column B on sheet 2 to display B4 from sheet 1.
Is there a formula I can put into sheet 2 cell B4 to make this happen? Does it make a difference if I reference A4/1 and I want B4/2 to display C4/1?
I'm looking to create a relationships between the 2 cells essentially. I hope it was clear enough to understand.