I have column A that has the following formula which references a numerical list in another worksheet (based on a data validation list selection in the main worksheet):
=IFERROR(VLOOKUP(H2&I2,Structure!C:D,2,FALSE),"")
So it will output a number. But i have column B on the main worksheet that is a simple boolean list (yes/no). When 'yes' is selected, i want it to add a predefined number (lets say 2), to the result of column A. How can i do this?
Bookmarks