Forum Discussion
IF Formula with "then" being a cell
I'm trying to do an If- Then formula, however I'd like to select a cell as the "then" as we may be changing the data and I don't want to have to rewrite the formula every time. Is this possible and i...
What would you like to have in the "then"? Can you give an example?
I'm trying to do an estimating sheet for Lineal feet/man/hour. Below is a snip-it of the sheet. I have the wall height as a drop-down list, and per that selection it changes what shows in the LinFt/Man/Hr column. As I have a running list of the averages below, I'd like the "then" to be the corresponding number to that height. If I can select the cell as the "then", I'm hoping that if the data in the cell changes it would automatically update.
Without the actual file it may be difficult to write a formula, but I guess you need something like:
"IF(<xxxxxxx>,VLOOKUP( ...... ), <yyyyyyy>).
The VLOOKUP part will find your wall height and return the average.
