microsoft excel – Not sure this is possible – Super User

microsoft excel – Not sure this is possible – Super User

I am looking to have excel look into the formula of a cell and then display a different cell based on that. confused yet?

OK…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.

This content was originally published here.

Leave a Reply

%d bloggers like this: