Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
in-cell dropdown for vlookup return
Uncertain if this can be done as described, but giving it a shot he
Seattle Portland San Francisco Los Angeles Truck 1 - 1,000 $1,000 Truck 2 - 2,000 Truck 3 - 3,000 $3,000 Truck 4 - 4,000 Truck 5 - 5,000 $5,000 City row text above is in b1:e1 . Column text is in a2:a6 , fed by field "TruckPrice" from range "Table" on anther sheet, which separates each truck and its price --- fields are Truck / Price / TruckPrice [=Truck&" "&Price]. Data validation for cells c2:e6 is the column text, ie the trucks and their prices. There is a table elsewhere that The objective is simple. Examples as outlined above: - drop "Truck 1 - 1,000" into b2 and the value in the cell becomes $1,000. - drop "Truck 3 - 3,000" into d4 and the value in the cell becomes $3,000. - drop "Truck 5 - 5,000" into c6 and the value in the cell becomes $5,000. .... And so on for the relevant range. The solution is apparently not so simple, it dropping down a text field in a cell to return a number in the same cell. Have tried numberous combinations of vlookup/offset, etc but to no avail. Can this be accomplished? Thanx in advance. - Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
return value from a dropdown list in other cell | Excel Discussion (Misc queries) | |||
select From dropdown and return another dropdown menu | Excel Discussion (Misc queries) | |||
VLookUp and DropDown List in the same cell | Excel Worksheet Functions | |||
Vlookup to Return Cell Name Not Value? | Excel Programming | |||
VLOOKUP or dropdown in the cell depending on selection in another | Excel Discussion (Misc queries) |