VLOOKUP

[Skyhook]

Is there a way to have a vlookup look at two cells where the user enters data and return the correct data in my range? In column A B C is my range. In column D and E the user would enter data and the vlookup would go to my range and return the value in column C and place that value in column E.

Thanks in advance

 

[Anne Troy]

"In column D and E the user would enter data and the vlookup would go to my range and return the value in column C and place that value in column E."

How can the user make entries in column D and E if you want to place a value in column E??

 

[Skyhook]

My bad. What I have in my “Range” is in Column A is feet in Column B is inches and in Column C is cubic feet per linear feet. So for instances if the user enters 10 in Column D and 11 in Column E Vlookup (or anything else that would work) would search my “range” and return 12 in Column F.

 

[Skyhook]

Thanks anyway. Found solution.