Support Board
Date/Time: Tue, 04 Mar 2025 21:33:29 +0000
Post From: Spreadsheet CELL not updating as expected + steps to reproduce.
| [2021-12-23 14:12:53] |
| User346098 - Posts: 47 |
|
Using Spreadsheet system for trading study, CELL not updating as expected steps to reproduce: works properly: example A 1) put formula on cell DM18 =IF(TRUE,"DEAD",FALSE) 2) put formula on cell BS30 =IF(DM18 = "DEAD", "CHEESE","BANANAS") 3) cell BS30 becomes CHEESE 4) clear formula from cell DM18 5) watch cell BS30 PROPERLY UPDATE and become "BANANAS" Broken: example B 1) put formula on DM18 =IF(TRUE,"DEAD",FALSE) 2) put formula on BS30 =IF(VLOOKUP("DEAD", DM3:DM600,1) = "DEAD", "CHEESE","BANANAS") 3) cell BS30 becomes "CHEESE" 4) clear cell DM18 , cell BS30 WRONGLY STAYS "CHEESE" and does not switch to BANANAS like with example A) I assume because VLOOKUP returns #N/A an error BUT example C below works Works properly: example C 1) put text string on DM18 "DEAD" 2) put formula on BS30 =IF(VLOOKUP("DEAD", DM3:DM600,1) = "DEAD", "CHEESE","BANANAS") 3) cell BS30 becomes "CHEESE" 4 clear cell DM18, cell BS30 BECOMES "BANANAS" ! so the question is how to make example B also work. and why does is not work ? |