Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlook up + Lists
I have a sheet that includes a dropdown list, what i would like is when i
pick a word form that list it populates data in another cell, The list is in cell B3, i then want it to look for the correct list on Sheet 3 and populate that information starting in cell A7 down I think it needs a lookup but if there is an easier way I would appreciaite some guidence Thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlook up + Lists
Assume that you have the lookup table in Sheet3 A7:B100
In your current sheet B3 you have the drop down In cell C3 enter formula =Vlookup(b3,Sheet3!A7:B100,2,0) The above formula will lookup the value in B3 in Sheet3 ColA and if a match is found return the second column of the array A7:B100...which is data in ColB -- Jacob "Shane" wrote: I have a sheet that includes a dropdown list, what i would like is when i pick a word form that list it populates data in another cell, The list is in cell B3, i then want it to look for the correct list on Sheet 3 and populate that information starting in cell A7 down I think it needs a lookup but if there is an easier way I would appreciaite some guidence Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlook UP | Excel Discussion (Misc queries) | |||
how if and vlook up is used | Excel Worksheet Functions | |||
VLOOK-pivot table expanding want to update vlook automatically | Excel Worksheet Functions | |||
VLOOK-pivot table expanding want to update vlook automatically | Excel Worksheet Functions | |||
VLOOK UP | Excel Discussion (Misc queries) |