Support Board

Date/Time: Fri, 03 May 2024 03:47:30 +0000

Post From: Error copying formula referencing another sheet

[2021-01-11 22:31:54] Link To Thread - Link To Post [Go To First Post]
ijtraderji - Posts: 6
Try this way: 1. In cells F2-F6 enter (one item per cell) This That Another One Two 2. In Cells H1-L1 enter (one item per cell) This That Another One Two 3. In cells H2-H7 enter the number 10 4. In cells I2-I7 enter the number 20 5. In cells J2-J7 enter the number 30 6. In cells K2-K7 enter the number 40 7. In cells L2-L7 enter the number 50 8. In cell H8 enter the formula: =IF($F2=H$1,H$2,"") The value should be 10 9. Copy this formula to I8:L8. All other cells will be empty. 10. Copy formula for cells H8:L8. 11. Paste to H9:L9, I9 will show value 20. 11. Paste to H10:L10, now all values show blank, although J10 should be 30. 12. Change the value in J1 to "A" and then back to "Another". J10 formula now populates with correct value of 30. See screenshot


Screenshot_2021-01-11_16-29-19.png / V - Attached On 2021-01-11 22:30:54 UTC - Size: 22.08 KB - 167 views