Dropdown Selection with lookup of whole list

[Darshan Shah]

Hello!

Hope you guys are safe & doing well.

Here I am attaching a sample file in which i need lookup list.

Example:

I have roll names in column B which has a data validation drop down. After selecting a Roll Name, In column C, I should get the whole list of Roll Numbers.

As attached in Sample File, for Cell B2, i need list of S Roll from Sheet2 which is from SR-1 to SR-200. Similarly, for B3, W Roll numbers i.e. from WR-1 to WR-30 should come.

Thanks for the time

[rollis13]

You will need to use a dependent drop down list.
First of all give a Name to the Roll Name (let's say Roll_Tag) and to every different Roll Numbers (let's say W_Roll, F_Roll, S_Roll, etc.)
In your Roll Name dropdown (column B) as Data Validation use =Roll_Tag and as Data Validation for Roll Number (column C) use =INDIRECT(SUBSTITUTE(B2," ","_")). You need to use Substitute since your names contain spaces (not permitted).
Pull down B2 and C2 as needed. I attached your updated file.

PS. this link could be helpful LINK

[Darshan Shah]

Yes!! Its working like a Gem. Thank you so much! Thumbs up!

[rollis13]

Glad having been of some help .