Jun 11 2020 12:04 AM
Hi guys I'm a bit stuck and would love your help!!
I need a formula which can use the contence of a cell as the cell reference in an offset formula. ie. say cell using sheet 2 below by referencing A1 I want to get the answer show in column B ie. Win1 and Win2, through referring back to where the results in column A came from (sheet 1) and offesting across 2 columns. Thanks in advance for any guidance!!
Sheet1
A | B | C | D |
23 | Win1 | ||
25 | Win2 |
Sheet 2
A | B | C |
=Sheet1!A1 | Win1 | |
=Sheet1!B2 | Win2 |
Jun 11 2020 02:06 AM
Jun 11 2020 04:22 PM