IF Formula with "then" being a cell

[Lisa11]

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 if so, how? 

Thank you! 

[#2]

@Lisa11 

What would you like to have in the "then"? Can you give an example?

[#3]

@Lisa11 -

[#4]

@Riny_van_Eekelen 

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.

[#5]

@Lisa11 

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. 

[#6]

@ChrisMendoza Thank you so much! I can't believe I didn't try that lol! 

[#7]

@Lisa11 -

Seeing this I might change to something more like: