Forum Discussion
Solved
Update value of cell based on conditions met in another table
Hello - I have a room and class schedule that must be built in Excel (I'd rather use a database) and I am wondering if it is possible to change the value of a cell in one table based on whether two ...
=IF(NOT(ISNA(VLOOKUP(B$1&$A2,sheet1!$A$2:$A$10&sheet1!$B$2:$B$10,1,FALSE))),"X","")You can try this formula which seems to work in my sheet. I've entered the formula in cell B2 and copied it across range B2:D5. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
=IF(NOT(ISNA(VLOOKUP(B$1&$A2,sheet1!$A$2:$A$10&sheet1!$B$2:$B$10,1,FALSE))),"X","")You can try this formula which seems to work in my sheet. I've entered the formula in cell B2 and copied it across range B2:D5. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
Yes! Thank you! I had to remove the table formatting to get it to work properly but my actual schedule isn't formatted as a table, anyway. Now to reverse-engineer it to make it work in my actual schedule. 🙂 Thank you so much!!!