Forum Discussion
hafsafathima38
Jul 06, 2022Copper Contributor
Fill cells in Sheet 1 with value on Sheet 2 - return value from same exact cell on Sheet 2
Sheet 1 Cell A1 input is "?" when entered, the cell should fetch/fill with value from Sheet 2 cell A1 (same cell only) If Sheet 2 Values are X X X X X X ...
Harun24HR
Jul 06, 2022Silver Contributor
It seems simple use of IF() function. Try =IF(A1<>"",Sheet2!A1,"")