copy below then go to formulas-> Name Manager---> select New --> give it a name as DROPDOWN in source box paste
=INDEX(Data!$C$2:$C$13,MATCH(Main!$B2,Data!$B$2:$B$13,0)):INDEX(Data!$C$2:$C$13,MATCH(Main!$B2,Data!$B$2:$B$13))
then select the range for data validation --> go to data--> data validation--> List in Source box typr =DROPDOWN
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks