I need to calculate $$$ costs in column H. In H 4, there is a formula to determine if "hr " is selected, then need to also select choice in column G... This results in $$ value in college H. But in the event that any other selection in column F (ea,cy,ls,m) I get value error in column H. Instead I need a "-" result. I believe I need a conditional vlookup but figure out how to combine.
Bookmarks