Vlook up + Lists

S

Shane

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
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup if statement help needed 2
use vlook to show the value of a cell using a formula 5
novice requires help with vlook up 1
Vlookup help please 1
Drop Down Lists 3
sort by name when user selects name on another worksheet 2
How do i show the drop down arrow for a list in Excel 1
Populate Data from Summary Sheet 5

Top