need help

G

Guest

Say I have data in column A and B where A1 relates to B1 (A2 to B2, etc.).
In J1 I have a drop down box with the data from column A. How do I get data
from Column B to appear in say K1 as it relates to whatever I choose in my
drop down from column A?
 
G

Guest

Try this:

With
J1: (a value from Col_A)

This formula returns the corresponding value from Col_B
K1: =VLOOKUP(J1,$A$1:$B$100,2,0)

Adjust range references to match your situation.

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 

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

Using drop-down lists 4
Dropdown List that populates another column 7
Copy conditional formatting across column in the same row 2
Really need some help with a multi conditional SumProduct 1
dependent drop down list 1
DATA VALIDATION/DROP DOWN LIST 1
Data Validation and drop-down list using IF, AND and what else? 8
Help with creating a formula 6

Top