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 | |
| X | |
| X | |
| X |
And on the empty sheet 1 input of "?" on any of the cells that has value in Sheet 2 should populate. I have been trying various formulas but can't seem to make it work.
1 Reply
- Harun24HRSilver ContributorIt seems simple use of IF() function. Try =IF(A1<>"",Sheet2!A1,"")