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?