Data Validation List Associated with a Cell Value Lookup
Hi
I have a workbook with two sheets where the RawData contains the required data which I am looking in my Output sheet.
In Output sheet, I want to have the list of all values (as a drop-down/ list) which are associated with the cell in column A. In another word I need the list of values for Kishore to be populated as a list (dropdown list) in column B in B1 Cell.
Please help me here.
Thanks,
Kishore.
I suggest making a pivot table and overlaying it with a named dynamic range. I could show you how this is done if you attach a sample workbook.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks