VLOOKUP

Skyhook · May 2nd, 2002, 01:43 PM

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 · May 2nd, 2002, 01:50 PM

"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 · May 2nd, 2002, 02:16 PM

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 · May 2nd, 2002, 03:34 PM

Thanks anyway. Found solution.

May 2nd, 2002, 01:50 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,512	"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?? __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 2nd, 2002, 01:43 PM	#1
Skyhook New Member Join Date: Apr 2002 Location: East Texas Posts: 38	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

May 2nd, 2002, 02:16 PM	#3
Skyhook New Member Join Date: Apr 2002 Location: East Texas Posts: 38	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.

May 2nd, 2002, 03:34 PM	#4
Skyhook New Member Join Date: Apr 2002 Location: East Texas Posts: 38	Thanks anyway. Found solution.