Is there anyway to display a column of Data from another sheet, in the same workbook, based on an entry in a drop-down. For example, A drop-down in A1 on sheet2 has options A, B, C, D, E. When A is selected in the drop-down list, data from sheet1 on column A is displayed on sheet 2 in column B. When C is selected in the drop-down. Data from column C in Sheet1 is displayed in Column B on sheet 2, etc.
Thank you!!
One way:
If you name your data in each column with the same name as you have in your dropdown, then you can use
=INDEX(INDIRECT($A$1),ROW(A1)) in column C dragged down
If your rows exactly match your rows of data on sheet1, i.e. they both start in row 2, this can be simplified to
=INDIRECT($A$1) dragged down.
Does this work for you? See attachment
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks