I need help - - trying to create an if statment (B3 in attached) that when true (based on drop down selection in B1) will point to a particular named range and create a drop down list in B3. Basically, if B1 = ABC, then the drop down list in B3, should show 111, 222, 333...
Hi and welcome to the forum.
You need to do some changes in your range of your data and then use INDIRECT function for this.
Hope to helps you.
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
Thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks