Returning Randomly Selected Value from Table based on Criteria

Viau1337

New Member
Joined
Jul 26, 2022
Messages
13
Office Version
  1. 365
Platform
  1. Windows
Hello! First time Poster, long time lurker.

I have been tasked with working on a solution to generate content based on a data set contained within multiple tables in different worksheets.


To make it simpler I'll name two tables and two worksheets.

Tables containing data will be named Cosmetic, Ortho and Pediatric

1658877704697.png


Cosmetic Worksheet Contains Table named WS_Cosmetic
1658875118022.png


Ortho Worksheet contains table name WS_Ortho
1658875144936.png


Pediatric Worksheet Contains table name WS_Pediatric

Each table has multiple columns. For easier communication, I'll name them Topic, Sub Topic and Stock Caption.

1658875018569.png


They are set like this because I know the data set is bound to change and be added on to and because there is A LOT of data spread into multiple categories and sub categories.

These Topics and Sub Topics are then available to select from a drop down menu in a Worksheet named INPUT

1658878099727.png


This list is basically a Multi Level Dependent drop down list.
I.E: I select Cosmetic from the topic drop down menu, Sub Topic will only allow me to choose what has been marked as a Cosmetic Sub Topic (in another worksheet as well). (Using =INDIRECT(SUBSTITUTE(a4," ","_")) formula) and so on.


My mission:
I need to be able to select 12 sub topics from the drop down menus, and generate in a separate worksheet (in my case named Calendar) non recurring results based on the sub topics selected from the drop down menu (Cells B4:B16)

I.E:
1658878664913.png


I've found the =INDEX(data,RANDBETWEEN(1,ROWS(data)),1) formula, but am struggling on a couple of things:
Firstly, how do I make it look at the selection of topics, and how do I make it search in all of my worksheets?


Minisheets:

Cell Formulas
RangeFormula
D2:D17D2=INDEX(,RANDBETWEEN(1,ROWS(data)),1)
D18:D40D18=INDEX(Table24[Sub Topic],RANDBETWEEN(1,ROWS(Table1[Final Caption])),1)
D42D42=TRANSPOSE(#REF!)
C2C2=INPUT!H1
C3:C49C3=C2+7
Press CTRL+SHIFT+ENTER to enter array formulas.


Drop down:

Master-Social-Media-Library-Sheet-Separation.xlsx
AB
3TopicSub Topic
4CosmeticSmile Makeover
5OrthoClear Aligners
6PediatricPediatric Dentistry (General)
7CosmeticSmile Makeover
8OrthoClear Aligners
9PediatricPediatric Dentistry (General)
10CosmeticSmile Makeover
11OrthoClear Aligners
12PediatricPediatric Dentistry (General)
13CosmeticSmile Makeover
14OrthoClear Aligners
15PediatricPediatric Dentistry (General)
16CosmeticSmile Makeover
INPUT
Cells with Data Validation
CellAllowCriteria
A4:A16List=TB_Topics
B4:B16List=INDIRECT(SUBSTITUTE(A4," ","_"))



Cosmetics Sheet:
Master-Social-Media-Library-Sheet-Separation.xlsx
ABCDEFGH
1TopicSub TopicStock CaptionImage PreviewImage LinkFinal CaptionNB TopicNB Sub Topic
2CosmeticCosmetic Dentistry (General)Looking to improve the overall look of your smile? At [PracticeName], we offer various cosmetic dental options to help you achieve a dazzling smile. If you are ready to smile confidently, give our office a call today at [PhoneNumber]!#NAME?Cosmetic_March-01.jpgLooking to improve the overall look of your smile? At Julias and Joes Teeth Pull Place, we offer various cosmetic dental options to help you achieve a dazzling smile. If you are ready to smile confidently, give our office a call today at (905) 616-6316!Cosmetic 1Cosmetic Dentistry (General) 1
3CosmeticCosmetic Dentistry (General)At [PracticeName], our cosmetic treatment options can help you get the bright, dazzling smile you desire! Call our office today at [PhoneNumber] to schedule a consultation for cosmetic dental treatment. #NAME?1117980_4_070721.jpgAt Julias and Joes Teeth Pull Place, our cosmetic treatment options can help you get the bright, dazzling smile you desire! Call our office today at (905) 616-6316 to schedule a consultation for cosmetic dental treatment. Cosmetic 2Cosmetic Dentistry (General) 2
4CosmeticCosmetic Dentistry (General)Want a drastic improvement in the appearance of your smile? With cosmetic dentistry at [PracticeName], the doctor can work with you to craft the smile you have always desired! Give our office a call today at [PhoneNumber] to learn more about our cosmetic options.#NAME?12.pngWant a drastic improvement in the appearance of your smile? With cosmetic dentistry at Julias and Joes Teeth Pull Place, the doctor can work with you to craft the smile you have always desired! Give our office a call today at (905) 616-6316 to learn more about our cosmetic options.Cosmetic 3Cosmetic Dentistry (General) 3
5CosmeticCosmetic Dentistry (General)Looking for a drastic improvement in the aesthetics of your smile? With our cosmetic dentistry treatments at [PracticeName], we can help you create a smile that you are proud to show off. Call our office today at [PhoneNumber] to schedule a consultation!#NAME?1.pngLooking for a drastic improvement in the aesthetics of your smile? With our cosmetic dentistry treatments at Julias and Joes Teeth Pull Place, we can help you create a smile that you are proud to show off. Call our office today at (905) 616-6316 to schedule a consultation!Cosmetic 4Cosmetic Dentistry (General) 4
6CosmeticCosmetic Dentistry (General)Get the confidence to show off your smile! With cosmetic dental treatments at [PracticeName], our team can help you craft a smile you are proud of! Call us today at [PhoneNumber] to schedule a consultation!#NAME?4.pngGet the confidence to show off your smile! With cosmetic dental treatments at Julias and Joes Teeth Pull Place, our team can help you craft a smile you are proud of! Call us today at (905) 616-6316 to schedule a consultation!Cosmetic 5Cosmetic Dentistry (General) 5
7CosmeticCosmetic Dentistry (General)With a customized cosmetic dental treatment plan from [PracticeName], we can help you craft a smile that you love showing off! We offer many cosmetic dental treatments, and will work with you to create a treatment plan you feel confident in. Give our office a call today at [PhoneNumber] to schedule a consultation appointment.#NAME?13.jpgWith a customized cosmetic dental treatment plan from Julias and Joes Teeth Pull Place, we can help you craft a smile that you love showing off! We offer many cosmetic dental treatments, and will work with you to create a treatment plan you feel confident in. Give our office a call today at (905) 616-6316 to schedule a consultation appointment.Cosmetic 6Cosmetic Dentistry (General) 6
8CosmeticCosmetic Dentistry (General)Looking to improve the look of your smile? Ask our team at [PracticeName] about our cosmetic dentistry solutions and get a smile you are proud to show off! Give our office a call today at [PhoneNumber] to schedule a consultation appointment.#NAME?https://www.dropbox.com/s/5i12vb8id7l5hsd/895082_Social%20Media%20Posts%20December_6D_010821.jpg?dl=0Looking to improve the look of your smile? Ask our team at Julias and Joes Teeth Pull Place about our cosmetic dentistry solutions and get a smile you are proud to show off! Give our office a call today at (905) 616-6316 to schedule a consultation appointment.Cosmetic 7Cosmetic Dentistry (General) 7
9CosmeticCosmetic Dentistry (General)How can cosmetic dentistry improve your smile? At [PracticeName], we custom tailor your treatment plan to achieve the results you want. Give our office a call today at [PhoneNumber] to schedule a consultation and begin the journey towards the smile of your dreams!#NAME?Cosmetic-1.pngHow can cosmetic dentistry improve your smile? At Julias and Joes Teeth Pull Place, we custom tailor your treatment plan to achieve the results you want. Give our office a call today at (905) 616-6316 to schedule a consultation and begin the journey towards the smile of your dreams!Cosmetic 8Cosmetic Dentistry (General) 8
10CosmeticCosmetic Dentistry (General)Our cosmetic treatments at [PracticeName] can be designed to fit your specific goals for your smile. Give us a call today at [PhoneNumber] to schedule a consultation.#NAME?Cosmetic-2png.pngOur cosmetic treatments at Julias and Joes Teeth Pull Place can be designed to fit your specific goals for your smile. Give us a call today at (905) 616-6316 to schedule a consultation.Cosmetic 9Cosmetic Dentistry (General) 9
11CosmeticCosmetic Dentistry (General)Smile confidently again with cosmetic dental treatments from [PracticeName]! Give our office a call today at [PhoneNumber] to learn about the treatments we offer and schedule an appointment.#NAME?Cosmetic-3.pngSmile confidently again with cosmetic dental treatments from Julias and Joes Teeth Pull Place! Give our office a call today at (905) 616-6316 to learn about the treatments we offer and schedule an appointment.Cosmetic 10Cosmetic Dentistry (General) 10
12CosmeticCosmetic Dentistry (General)Love what you see in the mirror! At [PracticeName], we custom tailor our treatment plans to each patient, helping you achieve the cosmetic results you want for your smile! Give our office a call today at [PhoneNumber] to schedule an appointment.#NAME?Cosmetic-4.pngLove what you see in the mirror! At Julias and Joes Teeth Pull Place, we custom tailor our treatment plans to each patient, helping you achieve the cosmetic results you want for your smile! Give our office a call today at (905) 616-6316 to schedule an appointment.Cosmetic 11Cosmetic Dentistry (General) 11
13CosmeticCosmetic Dentistry (General)Whether you want whitening, veneers, or a complete makeover of your smile, [PracticeName] can help you craft a smile you will love showing off! Ready to schedule a consultation? Give our office a call today at [PhoneNumber].#NAME?Cosmetic-5.pngWhether you want whitening, veneers, or a complete makeover of your smile, Julias and Joes Teeth Pull Place can help you craft a smile you will love showing off! Ready to schedule a consultation? Give our office a call today at (905) 616-6316.Cosmetic 12Cosmetic Dentistry (General) 12
14CosmeticCosmetic Dentistry (General)Looking for a cosmetic dentist? At [PracticeName], our team will work with you to help you achieve your goals for your smile. Give our office a call today at [PhoneNumber] to schedule an appointment.#NAME?Cosmetic-6.pngLooking for a cosmetic dentist? At Julias and Joes Teeth Pull Place, our team will work with you to help you achieve your goals for your smile. Give our office a call today at (905) 616-6316 to schedule an appointment.Cosmetic 13Cosmetic Dentistry (General) 13
15CosmeticCosmetic Dentistry (General)We can help you design the smile of your dreams! For quality cosmetic dentistry you can be confident in, give [PracticeName] a call today at [PhoneNumber].#NAME?Cosmetic-7.pngWe can help you design the smile of your dreams! For quality cosmetic dentistry you can be confident in, give Julias and Joes Teeth Pull Place a call today at (905) 616-6316.Cosmetic 14Cosmetic Dentistry (General) 14
16CosmeticCosmetic Dentistry (General)Need a cosmetic dentist? [PracticeName] is your one-stop-shop for all your cosmetic dental needs. Contact us today at [PhoneNumber], and one of our helpful team members will get you in for an appointment.#NAME?Cosmetic-8.pngNeed a cosmetic dentist? Julias and Joes Teeth Pull Place is your one-stop-shop for all your cosmetic dental needs. Contact us today at (905) 616-6316, and one of our helpful team members will get you in for an appointment.Cosmetic 15Cosmetic Dentistry (General) 15
17CosmeticSmile MakeoverLooking to completely transform your smile? With a smile makeover from [PracticeName], we will work with you to craft the smile of your dreams! Call us today at [PhoneNumber] to schedule a consultation.#NAME?Smile-Makeover-1.pngLooking to completely transform your smile? With a smile makeover from Julias and Joes Teeth Pull Place, we will work with you to craft the smile of your dreams! Call us today at (905) 616-6316 to schedule a consultation.Cosmetic 16Smile Makeover 1
18CosmeticSmile MakeoverAt [PracticeName], our smile makeover treatments are custom tailored to each patient's needs and desired results. Contact us today at [PhoneNumber] to start your journey towards the smile you have always dreamed of!#NAME?Smile-Makeover-2.pngAt Julias and Joes Teeth Pull Place, our smile makeover treatments are custom tailored to each patient's needs and desired results. Contact us today at (905) 616-6316 to start your journey towards the smile you have always dreamed of!Cosmetic 17Smile Makeover 2
19CosmeticSmile MakeoverShow off your smile again! Contact [PracticeName] today at [PhoneNumber] to learn more about our smile makeover treatments.#NAME?https://www.dropbox.com/s/f8hv766ms5be128/Smile-Makeover-4.png?dl=0Show off your smile again! Contact Julias and Joes Teeth Pull Place today at (905) 616-6316 to learn more about our smile makeover treatments.Cosmetic 18Smile Makeover 3
20CosmeticSmile MakeoverYou should feel proud showing off your smile! At [PracticeName], our smile makeover treatments allow our patients to craft a smile that they can feel confident in. Give our office a call today at [PhoneNumber] to schedule an appointment.#NAME?https://www.dropbox.com/s/rag1146r8khvrow/Smile-Makeover-5.png?dl=0You should feel proud showing off your smile! At Julias and Joes Teeth Pull Place, our smile makeover treatments allow our patients to craft a smile that they can feel confident in. Give our office a call today at (905) 616-6316 to schedule an appointment.Cosmetic 19Smile Makeover 4
21CosmeticSmile MakeoverMake your dream a reality with smile makeovers from [PracticeName]! Contact us today at [PhoneNumber] to learn more about our available treatment options.#NAME?https://www.dropbox.com/s/rdmeqrznuv44xfh/Smile-Makeover-6.png?dl=0Make your dream a reality with smile makeovers from Julias and Joes Teeth Pull Place! Contact us today at (905) 616-6316 to learn more about our available treatment options.Cosmetic 20Smile Makeover 5
22CosmeticSmile MakeoverWant to transform you smile drastically? Call our office today at [PhoneNumber] to learn about smile makeovers here at [PracticeName]!#NAME?https://www.dropbox.com/s/mpd6h93fik8qi8g/Smile-Makeover-7.png?dl=0Want to transform you smile drastically? Call our office today at (905) 616-6316 to learn about smile makeovers here at Julias and Joes Teeth Pull Place!Cosmetic 21Smile Makeover 6
23CosmeticSmile MakeoverAt [PracticeName], we offer customized smile makeovers, helping our patients feel confident showing off their smile! Contact us today at [PhoneNumber] to schedule a consultation.#NAME?https://www.dropbox.com/s/j4acezal090cp59/Smile-Makeover-8.png?dl=0At Julias and Joes Teeth Pull Place, we offer customized smile makeovers, helping our patients feel confident showing off their smile! Contact us today at (905) 616-6316 to schedule a consultation.Cosmetic 22Smile Makeover 7
24CosmeticSmile MakeoverA smile makeover here at [PracticeName] can be customized to fit your individual needs and get the results you want. If you are interested in learning more about how a smile makeover could improve your smile, contact our office today at [PhoneNumber].#NAME?https://www.dropbox.com/s/qby8gnbftd9du5y/Smile-Makeover-3.png?dl=0A smile makeover here at Julias and Joes Teeth Pull Place can be customized to fit your individual needs and get the results you want. If you are interested in learning more about how a smile makeover could improve your smile, contact our office today at (905) 616-6316.Cosmetic 23Smile Makeover 8
25CosmeticTeeth WhiteningInterested in professional whitening treatments? Give our office a call today at [PhoneNumber] and ask about our whitening options!#NAME?https://www.dropbox.com/s/qwq6encnhyaquif/Whitening_March-01.jpg?dl=0Interested in professional whitening treatments? Give our office a call today at (905) 616-6316 and ask about our whitening options!Cosmetic 24Teeth Whitening 1
26CosmeticTeeth WhiteningAt [PracticeName], our professional whitening treatments can help you achieve a brighter, whiter smile in a way which is most convenient for you. Call our office today at [PhoneNumber] to schedule an appointment for your next whitening treatment!#NAME?https://www.dropbox.com/s/az2kd5qz68p9h3h/TeethWhitening_April.jpg?dl=0At Julias and Joes Teeth Pull Place, our professional whitening treatments can help you achieve a brighter, whiter smile in a way which is most convenient for you. Call our office today at (905) 616-6316 to schedule an appointment for your next whitening treatment!Cosmetic 25Teeth Whitening 2
27CosmeticTeeth WhiteningWith our professional teeth whitening at [PracticeName], you can get noticably whiter teeth in a way that is convenient to you. Call our office today at [PhoneNumber] to learn about our teeth whitening options. #NAME?https://www.dropbox.com/s/rk9crhncbtw0ym2/1087785_Social%20Media%20Posts%20June%202021_V2_060421.jpg?dl=0With our professional teeth whitening at Julias and Joes Teeth Pull Place, you can get noticably whiter teeth in a way that is convenient to you. Call our office today at (905) 616-6316 to learn about our teeth whitening options. Cosmetic 26Teeth Whitening 3
28CosmeticTeeth WhiteningLooking for high-quality, professional teeth whitening solutions? Give our office a call today at [PhoneNumber] to learn more about our available options and schedule an appointment!#NAME?https://www.dropbox.com/s/c46hs175deg8v64/11.png?dl=0Looking for high-quality, professional teeth whitening solutions? Give our office a call today at (905) 616-6316 to learn more about our available options and schedule an appointment!Cosmetic 27Teeth Whitening 4
29CosmeticTeeth WhiteningAre you dissatisfied with your drug store whitening kit? Get high-quality, drastic results from [PracticeName] with our professional whitening treatments. Call our office today at [PhoneNumber] to learn more about the treatments we offer!#NAME?https://www.dropbox.com/s/r1kctasz7ylgllu/11.jpg?dl=0Are you dissatisfied with your drug store whitening kit? Get high-quality, drastic results from Julias and Joes Teeth Pull Place with our professional whitening treatments. Call our office today at (905) 616-6316 to learn more about the treatments we offer!Cosmetic 28Teeth Whitening 5
30CosmeticTeeth WhiteningAre drug store whitening products not giving you the whitening results you want? With our professional whitening treatments at [PracticeName], you can get the bright, dazzling smile that you want in a manner that is convenient for your lifestyle. Call us today at [PhoneNumber] to schedule an appointment!#NAME?https://www.dropbox.com/s/hv8tsi45c1081n1/4.jpg?dl=0Are drug store whitening products not giving you the whitening results you want? With our professional whitening treatments at Julias and Joes Teeth Pull Place, you can get the bright, dazzling smile that you want in a manner that is convenient for your lifestyle. Call us today at (905) 616-6316 to schedule an appointment!Cosmetic 29Teeth Whitening 6
31CosmeticTeeth WhiteningInterested in high quality, professional whitening? At [PracticeName], our whitening treatments can give you results unmatched by those of drug store whitening kits. Give our office a call today at [PhoneNumber] to schedule an appointment. #NAME?https://www.dropbox.com/s/7222enyl6oeo994/Teeth-Whitening-1.png?dl=0Interested in high quality, professional whitening? At Julias and Joes Teeth Pull Place, our whitening treatments can give you results unmatched by those of drug store whitening kits. Give our office a call today at (905) 616-6316 to schedule an appointment. Cosmetic 30Teeth Whitening 7
32CosmeticTeeth WhiteningAt [PracticeName], we offer many professional whitening options, helping you get a brighter smile in a way that is convenient to you. Give our office a call today at [PhoneNumber] to learn more about our options. #NAME?https://www.dropbox.com/s/bemtyhultj0bl5y/Teeth-Whitening-2.png?dl=0At Julias and Joes Teeth Pull Place, we offer many professional whitening options, helping you get a brighter smile in a way that is convenient to you. Give our office a call today at (905) 616-6316 to learn more about our options. Cosmetic 31Teeth Whitening 8
33CosmeticTeeth WhiteningProfessional whitening treatments from [PracticeName] can deliver results unmatched by any drug store whitening kit! Contact our office today at [PhoneNumber] to schedule your whitening appointment.#NAME?https://www.dropbox.com/s/goeig89iwcnz1k4/Teeth-Whitening-5.png?dl=0Professional whitening treatments from Julias and Joes Teeth Pull Place can deliver results unmatched by any drug store whitening kit! Contact our office today at (905) 616-6316 to schedule your whitening appointment.Cosmetic 32Teeth Whitening 9
34CosmeticTeeth WhiteningIs tooth discoloration making you hide your smile? With whitening treatments at [PracticeName], we can help you get drastic results so you can feel confident showing off your smile! Give our office a call today at [PhoneNumber] to schedule your appointment.#NAME?https://www.dropbox.com/s/5b8pvavu4ep7dac/Teeth-Whitening-6.png?dl=0Is tooth discoloration making you hide your smile? With whitening treatments at Julias and Joes Teeth Pull Place, we can help you get drastic results so you can feel confident showing off your smile! Give our office a call today at (905) 616-6316 to schedule your appointment.Cosmetic 33Teeth Whitening 10
35CosmeticTeeth WhiteningDrug store whitening kits don't stand a chance against our professional whitening treatments here at [PracticeName]! Contact us today at [PhoneNumber] to learn about our whitening options and schedule your appointment.#NAME?https://www.dropbox.com/s/zpux8sw8j1334y7/Teeth-Whitening-7.png?dl=0Drug store whitening kits don't stand a chance against our professional whitening treatments here at Julias and Joes Teeth Pull Place! Contact us today at (905) 616-6316 to learn about our whitening options and schedule your appointment.Cosmetic 34Teeth Whitening 11
36CosmeticTeeth WhiteningLove coffee but not tooth discoloration? With professional whitening treatments from [PracticeName], you can reduce or eliminate discolorations from coffee and other beverages, helping you feel confident showing off your smile! Contact our office today at [PhoneNumber] to schedule an appointment.#NAME?https://www.dropbox.com/s/i6zzna09ndf5bd7/Teeth-Whitening-3%20%281%29.png?dl=0Love coffee but not tooth discoloration? With professional whitening treatments from Julias and Joes Teeth Pull Place, you can reduce or eliminate discolorations from coffee and other beverages, helping you feel confident showing off your smile! Contact our office today at (905) 616-6316 to schedule an appointment.Cosmetic 35Teeth Whitening 12
37CosmeticTeeth WhiteningSmile bright with whitening treatments here at [PracticeName]! Contact us today at [PhoneNumber] and one of our helpful team members will help get you in for an appointment.#NAME?https://www.dropbox.com/s/snkcav205u7hth7/Teeth-Whitening-4.png?dl=0Smile bright with whitening treatments here at Julias and Joes Teeth Pull Place! Contact us today at (905) 616-6316 and one of our helpful team members will help get you in for an appointment.Cosmetic 36Teeth Whitening 13
38CosmeticTeeth WhiteningTooth discoloration can be caused by many things, including diet, smoking, medications, and more. With whitening treatments from [PracticeName], you can drastically improve discoloration of the tooth enamel, reducing or eliminating staining. To schedule your whitening appointement, contact our office today at [PhoneNumber].#NAME?https://www.dropbox.com/s/s15y78m9jfuadcy/Teeth-Whitening-8.png?dl=0Tooth discoloration can be caused by many things, including diet, smoking, medications, and more. With whitening treatments from Julias and Joes Teeth Pull Place, you can drastically improve discoloration of the tooth enamel, reducing or eliminating staining. To schedule your whitening appointement, contact our office today at (905) 616-6316.Cosmetic 37Teeth Whitening 14
39CosmeticVeneersVeneers are a great way to improve the look of stained, discolored, misshapen, and worn teeth, giving you the smile you have always dreamed of! If you are interested in dental veneers, give our office a call today at [PhoneNumber].#NAME?https://www.dropbox.com/s/jcpyhohzwsfh7b7/Post3_Veneers.jpg?dl=0Veneers are a great way to improve the look of stained, discolored, misshapen, and worn teeth, giving you the smile you have always dreamed of! If you are interested in dental veneers, give our office a call today at (905) 616-6316.Cosmetic 38Veneers 1
40CosmeticVeneersAre you interested in veneers? At [PracticeName], we recommend veneers to improve the aesthetics of your smile, eliminating chipped, mishappen, and discolored teeth. Call our office today at [PhoneNumber] to learn more about our available options.#NAME?https://www.dropbox.com/s/bhkwjtcf0uxc43u/Veneers_March-01.jpg?dl=0Are you interested in veneers? At Julias and Joes Teeth Pull Place, we recommend veneers to improve the aesthetics of your smile, eliminating chipped, mishappen, and discolored teeth. Call our office today at (905) 616-6316 to learn more about our available options.Cosmetic 39Veneers 2
41CosmeticVeneersLooking for a drastic change in your smile? With porcelain veneers, you can get dramatic results that will make you proud to smile! Give our office a call today at [PhoneNumber] to schedule your consultation.#NAME?https://www.dropbox.com/s/kvzdb0cmwer4lvw/1063175_Social%20Media%20Posts%20-%20May%202021_02a_051121.jpg?dl=0Looking for a drastic change in your smile? With porcelain veneers, you can get dramatic results that will make you proud to smile! Give our office a call today at (905) 616-6316 to schedule your consultation.Cosmetic 40Veneers 3
42CosmeticVeneersWith dental veneers, you can improve the appearance of your smile drastically, eliminating chips, cracks, and gaps. Call our office today at [PhoneNumber] to schedule a consultation!#NAME?https://www.dropbox.com/s/7czv2q3f5127kph/1087785_Social%20Media%20Posts%20June%202021_V3_060421.jpg?dl=0With dental veneers, you can improve the appearance of your smile drastically, eliminating chips, cracks, and gaps. Call our office today at (905) 616-6316 to schedule a consultation!Cosmetic 41Veneers 4
43CosmeticVeneersLooking to drastically transform your smile? With veneers, you can repair chipped, cracked, or misshapened teeth with this minimally invasive treatment option. Call our office today at [PhoneNumber] to learn more!#NAME?https://www.dropbox.com/s/yh6o3f7xhpeo29e/1117980_5_070721.jpg?dl=0Looking to drastically transform your smile? With veneers, you can repair chipped, cracked, or misshapened teeth with this minimally invasive treatment option. Call our office today at (905) 616-6316 to learn more!Cosmetic 42Veneers 5
44CosmeticVeneersInterested in giving your smile a facelift? With veneers from [PracticeName], you can drastically change the appearance of your teeth without invasive procedures. Give our office a call today at [PhoneNumber] to schedule a consultation!#NAME?https://www.dropbox.com/s/u5sxfw2eyzdcc2p/3.jpg?dl=0Interested in giving your smile a facelift? With veneers from Julias and Joes Teeth Pull Place, you can drastically change the appearance of your teeth without invasive procedures. Give our office a call today at (905) 616-6316 to schedule a consultation!Cosmetic 43Veneers 6
45CosmeticVeneersVeneers are a great cosmetic option to give your smile a facelift! If you are interested in learning more about veneers, give our office a call today at [PhoneNumber].#NAME?https://www.dropbox.com/s/q13bcdjx39u3dti/2.jpg?dl=0Veneers are a great cosmetic option to give your smile a facelift! If you are interested in learning more about veneers, give our office a call today at (905) 616-6316.Cosmetic 44Veneers 7
46CosmeticVeneersVeneers can improve the size, color, shape and spacing of your teeth, helping you achieve a smile you can feel confident in! Call our office today at [PhoneNumber] to learn more.#NAME?https://www.dropbox.com/s/2uji7nxee5wkfbx/895082_Social%20Media%20Posts%20December_6I_010821.jpg?dl=0Veneers can improve the size, color, shape and spacing of your teeth, helping you achieve a smile you can feel confident in! Call our office today at (905) 616-6316 to learn more.Cosmetic 45Veneers 8
47CosmeticVeneersHow can veneers improve your smile? With veneers from [PracticeName], you can completely transform the look of your smile, eliminating imperfections to create a dazzling smile! Give our office a call today at [PhoneNumber] to schedule a consultation.#NAME?https://www.dropbox.com/s/pecv2uz97govp9u/Veneers-1.png?dl=0How can veneers improve your smile? With veneers from Julias and Joes Teeth Pull Place, you can completely transform the look of your smile, eliminating imperfections to create a dazzling smile! Give our office a call today at (905) 616-6316 to schedule a consultation.Cosmetic 46Veneers 9
48CosmeticVeneersVeneers are thin, outer shells that are applied to the the teeth to improve the appearance of the teeth. At [PracticeName], we customize your veneers to craft the smile that you have always wanted. If you are interested in veneers, give our office a call today at [PhoneNumber] to schedule a consultation appointment.#NAME?https://www.dropbox.com/s/15t6n86ygwo5406/Veneers-2.png?dl=0Veneers are thin, outer shells that are applied to the the teeth to improve the appearance of the teeth. At Julias and Joes Teeth Pull Place, we customize your veneers to craft the smile that you have always wanted. If you are interested in veneers, give our office a call today at (905) 616-6316 to schedule a consultation appointment.Cosmetic 47Veneers 10
49CosmeticVeneersLooking to improve imperfections in your smile? Veneers from [PracticeName] may be your solution! Contact our office today at [PhoneNumber] to learn more about treatment with dental veneers!#NAME?https://www.dropbox.com/s/b48e4dx95yt25mm/Veneers-3.png?dl=0Looking to improve imperfections in your smile? Veneers from Julias and Joes Teeth Pull Place may be your solution! Contact our office today at (905) 616-6316 to learn more about treatment with dental veneers!Cosmetic 48Veneers 11
50CosmeticVeneersDrastic results with minimally invasive treatment? Veneers from [PracticeName] are a great option for those who want to completely transform their smile! To learn more about how veneers can improve your smile, contact us today at [PhoneNumber] to schedule a consultation appointment.#NAME?https://www.dropbox.com/s/ycfvvqpf2bb855e/Veneers-4.png?dl=0Drastic results with minimally invasive treatment? Veneers from Julias and Joes Teeth Pull Place are a great option for those who want to completely transform their smile! To learn more about how veneers can improve your smile, contact us today at (905) 616-6316 to schedule a consultation appointment.Cosmetic 49Veneers 12
51CosmeticVeneersVeneers are thin outer shells for the teeth that drastically improve the appearance of your smile with a minimally invasive procedure. Call [PracticeName] today at [PhoneNumber] to learn more about how veneers can benefit your smile!#NAME?https://www.dropbox.com/s/3ji385tbfkbxznj/Veneers-5.png?dl=0Veneers are thin outer shells for the teeth that drastically improve the appearance of your smile with a minimally invasive procedure. Call Julias and Joes Teeth Pull Place today at (905) 616-6316 to learn more about how veneers can benefit your smile!Cosmetic 50Veneers 13
52CosmeticVeneersVeneers from [PracticeName] allow you to completely transform your smile, correcting imperfections such as discoloration and chipping. Give our office a call today at [PhoneNumber] to schedule a consultation appointment.#NAME?https://www.dropbox.com/s/akq997shq0yhuhd/Veneers-6.png?dl=0Veneers from Julias and Joes Teeth Pull Place allow you to completely transform your smile, correcting imperfections such as discoloration and chipping. Give our office a call today at (905) 616-6316 to schedule a consultation appointment.Cosmetic 51Veneers 14
53CosmeticVeneersAt [PracticeName], we recommend veneers to anyone who wants a drastic improvement in the appearance of their smile. To learn how veneers could benefit your smile, call our office today at [PhoneNumber] to schedule a consultation appointment.#NAME?https://www.dropbox.com/s/bkl0s2gcpcf422j/Veneers-7.png?dl=0At Julias and Joes Teeth Pull Place, we recommend veneers to anyone who wants a drastic improvement in the appearance of their smile. To learn how veneers could benefit your smile, call our office today at (905) 616-6316 to schedule a consultation appointment.Cosmetic 52Veneers 15
54CosmeticVeneersOur team at [PracticeName] can help you craft a smile that you can feel proud to show off! Start your journey towards a dazzling smile; contact us today at [PhoneNumber].#NAME?https://www.dropbox.com/s/lgwth3pmyxtg910/Veneers-8.png?dl=0Our team at Julias and Joes Teeth Pull Place can help you craft a smile that you can feel proud to show off! Start your journey towards a dazzling smile; contact us today at (905) 616-6316.Cosmetic 53Veneers 16
55CosmeticVeneersVeneers are a great solution for improving discolored, chipped, or misshapen teeth. Contact [PracticeName] today at [PhoneNumber] to schedule a consultation for veneers.#NAME?https://www.dropbox.com/s/ranajgegvpzvug0/Teeth-Whitening-3.png?dl=0Veneers are a great solution for improving discolored, chipped, or misshapen teeth. Contact Julias and Joes Teeth Pull Place today at (905) 616-6316 to schedule a consultation for veneers.Cosmetic 54Veneers 17
Cosmetic
Cell Formulas
RangeFormula
D2:D55D2=IMAGE((SUBSTITUTE(E2,"?dl=0","?dl=1")), 1)
F2:F55F2=SUBSTITUTE(SUBSTITUTE(C2, "[PracticeName]",INPUT!$B$1),"[PhoneNumber]",INPUT!$E$1)


Ortho Sheet:

Master-Social-Media-Library-Sheet-Separation.xlsx
ABCDEFGH
1TopicSub TopicStock CaptionImage PreviewImage LinkFinal CaptionNB TopicNB Sub Topic
2OrthoBracesAt [PracticeName], we often recommend braces to teenagers who have issues with crooked teeth, crowding, and more. We will work with you to create a treatment plan that works for your child. Give our office a call today at [PhoneNumber] to schedule a consultation appointment.#NAME?https://www.dropbox.com/s/m9bdix6vj155a5r/1063175_Social%20Media%20Posts%20-%20May%202021_08b_051321.jpg?dl=0At Julias and Joes Teeth Pull Place, we often recommend braces to teenagers who have issues with crooked teeth, crowding, and more. We will work with you to create a treatment plan that works for your child. Give our office a call today at (905) 616-6316 to schedule a consultation appointment.Ortho 1Braces 1
3OrthoClear AlignersSmile like you mean it! Give our office a call at [PhoneNumber] to ask about our clear aligner treatments, and get a straight, dazzling smile you are proud to show off!#NAME?https://www.dropbox.com/s/zichecn7yo347ou/Invisalign_April.jpg?dl=0Smile like you mean it! Give our office a call at (905) 616-6316 to ask about our clear aligner treatments, and get a straight, dazzling smile you are proud to show off!Ortho 2Clear Aligners 1
4OrthoClear AlignersWith clear aligners from [PracticeName], you can get a straight, dazzling smile with a series of clear aligners that will move your teeth into place while looking natural and discreet. Give our office a call today at [PhoneNumber] to learn more!#NAME?https://www.dropbox.com/s/seon320jgz9h746/2.jpg?dl=0With clear aligners from Julias and Joes Teeth Pull Place, you can get a straight, dazzling smile with a series of clear aligners that will move your teeth into place while looking natural and discreet. Give our office a call today at (905) 616-6316 to learn more!Ortho 3Clear Aligners 2
5OrthoClear AlignersClear aligners are a great option for orthodontic treatment, allowing you to improve your smile without the hassle of traditional braces. If you are interested in treatment with clear aligners, give our office a call today at [PhoneNumber] to schedule a consultation. #NAME?https://www.dropbox.com/s/1soekusqeb8axyn/8.png?dl=0Clear aligners are a great option for orthodontic treatment, allowing you to improve your smile without the hassle of traditional braces. If you are interested in treatment with clear aligners, give our office a call today at (905) 616-6316 to schedule a consultation. Ortho 4Clear Aligners 3
6OrthoClear AlignersWith clear aligners, you can straighten your teeth without the unsightly appearance and hassle of traditional metal braces. Call our office today at [PhoneNumber] to schedule a consultation!#NAME?https://www.dropbox.com/s/3fogu478brzobhe/12-.jpg?dl=0With clear aligners, you can straighten your teeth without the unsightly appearance and hassle of traditional metal braces. Call our office today at (905) 616-6316 to schedule a consultation!Ortho 5Clear Aligners 4
7OrthoClear AlignersWith clear aligners, you can get the orthodontic treatment you want without the discomfort and hassle that comes with traditional braces. If you are looking to get a straighter smile, give our office a call today at [PhoneNumber] to schedule your consultation!#NAME?https://www.dropbox.com/s/rs9mdub4xm3ef73/3.jpg?dl=0With clear aligners, you can get the orthodontic treatment you want without the discomfort and hassle that comes with traditional braces. If you are looking to get a straighter smile, give our office a call today at (905) 616-6316 to schedule your consultation!Ortho 6Clear Aligners 5
8OrthoClear AlignersInterested in clear aligners? At [PracticeName], we offer orthodontic treatment with clear aligners, allowing you to improve your smile without the need for traditional braces. Give our office a call today at [PhoneNumber] to schedule a consultation.#NAME?https://www.dropbox.com/s/6rxxk6776jgl5xu/Clear-Aligners-1.png?dl=0Interested in clear aligners? At Julias and Joes Teeth Pull Place, we offer orthodontic treatment with clear aligners, allowing you to improve your smile without the need for traditional braces. Give our office a call today at (905) 616-6316 to schedule a consultation.Ortho 7Clear Aligners 6
9OrthoClear AlignersStraight teeth without wires and brackets? Clear aligner treatment from [PracticeName] can help you get a dazzling, straight smile with a series of clear trays work throughout the day and night. If you would like to learn more about clear aligners, contact us today at [PhoneNumber] and we will gladly answer any questions you have.#NAME?https://www.dropbox.com/s/kxaees3k28rzfix/Clear-Aligners-2.png?dl=0Straight teeth without wires and brackets? Clear aligner treatment from Julias and Joes Teeth Pull Place can help you get a dazzling, straight smile with a series of clear trays work throughout the day and night. If you would like to learn more about clear aligners, contact us today at (905) 616-6316 and we will gladly answer any questions you have.Ortho 8Clear Aligners 7
10OrthoClear AlignersDiscreetly straighten your teeth with clear aligners from [PracticeName]. If you are interested in learning more about how clear aligners can improve your smile, give us a call today at [PhoneNumber].#NAME?https://www.dropbox.com/s/a3xc35ubwnd8fer/Clear-Aligners-3.png?dl=0Discreetly straighten your teeth with clear aligners from Julias and Joes Teeth Pull Place. If you are interested in learning more about how clear aligners can improve your smile, give us a call today at (905) 616-6316.Ortho 9Clear Aligners 8
11OrthoClear AlignersInvisible braces?! Clear aligners from [PracticeName] move your teeth with a series of clear trays, custom made to fit your smile and get the results you want. Call us today at [PhoneNumber] to schedule your consultation and start your journey towards a straighter smile!#NAME?https://www.dropbox.com/s/tuaqgx83hhhetru/Clear-Aligners-5.png?dl=0Invisible braces?! Clear aligners from Julias and Joes Teeth Pull Place move your teeth with a series of clear trays, custom made to fit your smile and get the results you want. Call us today at (905) 616-6316 to schedule your consultation and start your journey towards a straighter smile!Ortho 10Clear Aligners 9
12OrthoClear AlignersClear aligners from [PracticeName] are a great alternative to traditional braces. They move the teeth into position using a series of clear trays, helping you achieve the orthodontic results you desire without the hassle of wires and brackets. If you are interested in clear aligner treatment, give our team a call today at [PhoneNumber] to schedule a consultation. #NAME?https://www.dropbox.com/s/y1yhljxtvhsvgjf/Clear-Aligners-6.png?dl=0Clear aligners from Julias and Joes Teeth Pull Place are a great alternative to traditional braces. They move the teeth into position using a series of clear trays, helping you achieve the orthodontic results you desire without the hassle of wires and brackets. If you are interested in clear aligner treatment, give our team a call today at (905) 616-6316 to schedule a consultation. Ortho 11Clear Aligners 10
13OrthoClear AlignersClear aligners make orthodontic treatment a breeze! With clear aligners from [PracticeName], you solve a variety of orthodontic issues, giving you a smile you feel proud to show off. If you are interested in learning how clear aligners could improve your smile, contact us today at [PhoneNumber] to schedule an appointment. #NAME?https://www.dropbox.com/s/kxt8te4t151sx6v/Smile-Makeover-9.png?dl=0Clear aligners make orthodontic treatment a breeze! With clear aligners from Julias and Joes Teeth Pull Place, you solve a variety of orthodontic issues, giving you a smile you feel proud to show off. If you are interested in learning how clear aligners could improve your smile, contact us today at (905) 616-6316 to schedule an appointment. Ortho 12Clear Aligners 11
14OrthoClear AlignersClear aligners are a clear alternative to traditional orthodontic treatment with braces. If you are interested in clear aligner treatment at [PracticeName], give us a call today at [PhoneNumber] to schedule an appointment.#NAME?https://www.dropbox.com/s/le1x8nl0z7606el/Smile-Makeover-11.png?dl=0Clear aligners are a clear alternative to traditional orthodontic treatment with braces. If you are interested in clear aligner treatment at Julias and Joes Teeth Pull Place, give us a call today at (905) 616-6316 to schedule an appointment.Ortho 13Clear Aligners 12
15OrthoClear AlignersIf you are interested in learning more about the clear aligner treatments here at [PracticeName], contact our office today at [PhoneNumber] to schedule a consultation. #NAME?https://www.dropbox.com/s/ykb6v4g9n1zl6b7/Clear-Aligners-4.png?dl=0If you are interested in learning more about the clear aligner treatments here at Julias and Joes Teeth Pull Place, contact our office today at (905) 616-6316 to schedule a consultation. Ortho 14Clear Aligners 13
16OrthoInvisalignFall in love with your smile! Call our office today at [PhoneNumber] to ask about Invisalign, and get a straight, dazzling smile you are proud to show off!#NAME?https://www.dropbox.com/s/ista8s4zsdwaysh/Invisalign_March-01.png?dl=0Fall in love with your smile! Call our office today at (905) 616-6316 to ask about Invisalign, and get a straight, dazzling smile you are proud to show off!Ortho 15Invisalign 1
Ortho
Cell Formulas
RangeFormula
D2:D16D2=IMAGE((SUBSTITUTE(E2,"?dl=0","?dl=1")), 1)
F2:F16F2=SUBSTITUTE(SUBSTITUTE(C2, "[PracticeName]",INPUT!$B$1),"[PhoneNumber]",INPUT!$E$1)


Pediatric Sheet:

Topics List:
Master-Social-Media-Library-Sheet-Separation.xlsx
A
2Topics
3Cosmetic
4Ortho
5Endodontics
6General Dentistry
7Periodontics
8Oral Surgery
9Restorative
10Pediatric
11MedSpa
12Holiday
Topics


SubTopics List:

Master-Social-Media-Library-Sheet-Separation.xlsx
ABCDEFGHIJ
16CosmeticOrthoEndodonticsGeneral DentistryPeriodonticsOral SurgeryRestorativePediatricMedSpaHoliday
17Cosmetic Dentistry (General)BracesCBCTCleaningDeep CleaningAll-On-4CrownsCleaning & ExamAnti-AgingDecember Holidays
18Smile MakeoverClear AlignersEndodontic SurgeryCleaning & ExamLaser DentistryDental ImplantsDental BridgeDental FactsBody and Facial ContouringNew Year
19Teeth WhiteningInvisalignEndodonticsDental Care (General)Gummy Smile TreatmentBone GraftingDental ImplantsFillingsBotox
20VeneersRetreatmentsEmergency DentistryPeriodontal DiseaseWisdom Teeth RemovalFluoride TreatmentCellulite Reduction
21Root CanalsExamPeriodontics (General)Impacted TeethPediatric Dentistry (General)
22Fluoride TreatmentExtractionsSealants
23Oral Cancer ScreeningX-Ray
24Sealants
25Sedation Dentistry
26Sleep Apnea
27X-Rays
Topics


Sorry in advance if I'm bad at explaining, I'm not quite fluent in english :P

Cheers!
 

Attachments

  • 1658875028511.png
    1658875028511.png
    2.4 KB · Views: 8
  • 1658877846848.png
    1658877846848.png
    23.2 KB · Views: 7

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Oh boy, I forgot to say :
My mission:
I need to be able to select 12 sub topics from the drop down menus, and generate in a separate worksheet (in my case named Calendar) non recurring results that are found in my multiple tables.
 
Upvote 0
Ok. Update.
I managed to almost get the results wanted with formula =LET(Fltr,FILTER(Table1[Final Caption],Table1[Sub Topic]=Calendar!D41),INDEX(SORTBY(Fltr,RANDARRAY(ROWS(Fltr))),{1,2})) in one cell, and on the left cell formula: =INDEX(Table24[Sub Topic],RANDBETWEEN(1,ROWS(Table24[Sub Topic])),1)

Master-Social-Media-Library-Sheet-Separation.xlsx
DE
1TopicLink to Post
2ExtractionsIt is our goal at Julias and Joes Teeth Pull Place to make the process of getting a tooth removed as easy as possible for our patients. Call our office today at (905) 616-6316 to learn more about tooth extractions!
3Smile MakeoverYou should feel proud showing off your smile! At Julias and Joes Teeth Pull Place, our smile makeover treatments allow our patients to craft a smile that they can feel confident in. Give our office a call today at (905) 616-6316 to schedule an appointment.
4Smile MakeoverA smile makeover here at Julias and Joes Teeth Pull Place can be customized to fit your individual needs and get the results you want. If you are interested in learning more about how a smile makeover could improve your smile, contact our office today at (905) 616-6316.
5VeneersLooking to drastically transform your smile? With veneers, you can repair chipped, cracked, or misshapened teeth with this minimally invasive treatment option. Call our office today at (905) 616-6316 to learn more!
6Clear AlignersWith clear aligners, you can straighten your teeth without the unsightly appearance and hassle of traditional metal braces. Call our office today at (905) 616-6316 to schedule a consultation!
7VeneersVeneers can improve the size, color, shape and spacing of your teeth, helping you achieve a smile you can feel confident in! Call our office today at (905) 616-6316 to learn more.
8Clear AlignersStraight teeth without wires and brackets? Clear aligner treatment from Julias and Joes Teeth Pull Place can help you get a dazzling, straight smile with a series of clear trays work throughout the day and night. If you would like to learn more about clear aligners, contact us today at (905) 616-6316 and we will gladly answer any questions you have.
9Root CanalsPain and sensitivity in your teeth may be a sign that you need a root canal. If you are experiencing these symptoms, give our office a call today at (905) 616-6316 to schedule an appointment for treatment.
10Dental BridgeA dental bridge is a great way to restore a missing tooth for individuals who do not want or cannot get dental implants. Bridges help to prevent many issues that can arise from leaving a gap in your smile. If you are interested in learning more about dental bridges, call our office today at (905) 616-6316 to schedule your consulatation!
11Smile MakeoverAt Julias and Joes Teeth Pull Place, we offer customized smile makeovers, helping our patients feel confident showing off their smile! Contact us today at (905) 616-6316 to schedule a consultation.
12Root CanalsThis is a Great Topic for Julias and Joes Teeth Pull Place so call us at (905) 616-6316
13RetreatmentsThis is a Great Topic for Julias and Joes Teeth Pull Place so call us at (905) 616-6316
14VeneersWith dental veneers, you can improve the appearance of your smile drastically, eliminating chips, cracks, and gaps. Call our office today at (905) 616-6316 to schedule a consultation!
15Clear AlignersStraight teeth without wires and brackets? Clear aligner treatment from Julias and Joes Teeth Pull Place can help you get a dazzling, straight smile with a series of clear trays work throughout the day and night. If you would like to learn more about clear aligners, contact us today at (905) 616-6316 and we will gladly answer any questions you have.
16Clear AlignersClear aligners make orthodontic treatment a breeze! With clear aligners from Julias and Joes Teeth Pull Place, you solve a variety of orthodontic issues, giving you a smile you feel proud to show off. If you are interested in learning how clear aligners could improve your smile, contact us today at (905) 616-6316 to schedule an appointment.
17Smile MakeoverAt Julias and Joes Teeth Pull Place, we offer customized smile makeovers, helping our patients feel confident showing off their smile! Contact us today at (905) 616-6316 to schedule a consultation.
18Clear AlignersClear aligners are a great option for orthodontic treatment, allowing you to improve your smile without the hassle of traditional braces. If you are interested in treatment with clear aligners, give our office a call today at (905) 616-6316 to schedule a consultation.
19ExtractionsWhen you need a tooth removed, you can trust the team at Julias and Joes Teeth Pull Place to provide top-quality care. Give us a call today at (905) 616-6316 to schedule an appointment.
20Fluoride TreatmentFluoride treatments here at Julias and Joes Teeth Pull Place are a great way to protect and improve the strength of the teeth for those who are prone to regular cavities. If you are interested in learning more about fluoride treatments, give us a call today at (905) 616-6316.
21RetreatmentsThis is a Great Topic for Julias and Joes Teeth Pull Place so call us at (905) 616-6316
22RetreatmentsThis is a Great Topic for Julias and Joes Teeth Pull Place so call us at (905) 616-6316
23ExtractionsAn extraction involves removing a tooth that has become a risk to your oral health. When doctors are unable to save a tooth, or prior to getting a dental implant placed, you may need to have a tooth removed completely. At Julias and Joes Teeth Pull Place, we make the process easy and comfortable for our patients. Give our office a call today at (905) 616-6316 to schedule an appointment.
24Cellulite ReductionReduce unwanted cellulite with treatments from Julias and Joes Teeth Pull Place! Call our office today at (905) 616-6316 to schedule your treatment.
25VeneersAt Julias and Joes Teeth Pull Place, we recommend veneers to anyone who wants a drastic improvement in the appearance of their smile. To learn how veneers could benefit your smile, call our office today at (905) 616-6316 to schedule a consultation appointment.
26Clear AlignersWith clear aligners, you can get the orthodontic treatment you want without the discomfort and hassle that comes with traditional braces. If you are looking to get a straighter smile, give our office a call today at (905) 616-6316 to schedule your consultation!
27InvisalignFall in love with your smile! Call our office today at (905) 616-6316 to ask about Invisalign, and get a straight, dazzling smile you are proud to show off!
28Pediatric Dentistry (General)At Julias and Joes Teeth Pull Place, we focus on helping your child grow up with a healthy smile and optimal oral health. If you are looking for a pediatric dentist, contact our office today at (905) 616-6316 to schedule an appointment.
Calendar
Cell Formulas
RangeFormula
D2:D28D2=INDEX(Table24[Sub Topic],RANDBETWEEN(1,ROWS(Table24[Sub Topic])),1)
E2:F28E2=LET(Fltr,FILTER(Table1[Final Caption],Table1[Sub Topic]=Calendar!D2),INDEX(SORTBY(Fltr,RANDARRAY(ROWS(Fltr))),{1,2}))
Dynamic array formulas.


Data is pulled from worksheet called all data:

Master-Social-Media-Library-Sheet-Separation.xlsx
ABCDEF
1TopicSub TopicStock CaptionImage PreviewImage LinkFinal Caption
2CosmeticCosmetic Dentistry (General)Looking to improve the overall look of your smile? At [PracticeName], we offer various cosmetic dental options to help you achieve a dazzling smile. If you are ready to smile confidently, give our office a call today at [PhoneNumber]!#NAME?Cosmetic_March-01.jpgLooking to improve the overall look of your smile? At Julias and Joes Teeth Pull Place, we offer various cosmetic dental options to help you achieve a dazzling smile. If you are ready to smile confidently, give our office a call today at (905) 616-6316!
3CosmeticCosmetic Dentistry (General)At [PracticeName], our cosmetic treatment options can help you get the bright, dazzling smile you desire! Call our office today at [PhoneNumber] to schedule a consultation for cosmetic dental treatment. #NAME?1117980_4_070721.jpgAt Julias and Joes Teeth Pull Place, our cosmetic treatment options can help you get the bright, dazzling smile you desire! Call our office today at (905) 616-6316 to schedule a consultation for cosmetic dental treatment.
4CosmeticCosmetic Dentistry (General)Want a drastic improvement in the appearance of your smile? With cosmetic dentistry at [PracticeName], the doctor can work with you to craft the smile you have always desired! Give our office a call today at [PhoneNumber] to learn more about our cosmetic options.#NAME?12.pngWant a drastic improvement in the appearance of your smile? With cosmetic dentistry at Julias and Joes Teeth Pull Place, the doctor can work with you to craft the smile you have always desired! Give our office a call today at (905) 616-6316 to learn more about our cosmetic options.
5CosmeticCosmetic Dentistry (General)Looking for a drastic improvement in the aesthetics of your smile? With our cosmetic dentistry treatments at [PracticeName], we can help you create a smile that you are proud to show off. Call our office today at [PhoneNumber] to schedule a consultation!#NAME?1.pngLooking for a drastic improvement in the aesthetics of your smile? With our cosmetic dentistry treatments at Julias and Joes Teeth Pull Place, we can help you create a smile that you are proud to show off. Call our office today at (905) 616-6316 to schedule a consultation!
6CosmeticCosmetic Dentistry (General)Get the confidence to show off your smile! With cosmetic dental treatments at [PracticeName], our team can help you craft a smile you are proud of! Call us today at [PhoneNumber] to schedule a consultation!#NAME?4.pngGet the confidence to show off your smile! With cosmetic dental treatments at Julias and Joes Teeth Pull Place, our team can help you craft a smile you are proud of! Call us today at (905) 616-6316 to schedule a consultation!
7CosmeticCosmetic Dentistry (General)With a customized cosmetic dental treatment plan from [PracticeName], we can help you craft a smile that you love showing off! We offer many cosmetic dental treatments, and will work with you to create a treatment plan you feel confident in. Give our office a call today at [PhoneNumber] to schedule a consultation appointment.#NAME?13.jpgWith a customized cosmetic dental treatment plan from Julias and Joes Teeth Pull Place, we can help you craft a smile that you love showing off! We offer many cosmetic dental treatments, and will work with you to create a treatment plan you feel confident in. Give our office a call today at (905) 616-6316 to schedule a consultation appointment.
8CosmeticCosmetic Dentistry (General)Looking to improve the look of your smile? Ask our team at [PracticeName] about our cosmetic dentistry solutions and get a smile you are proud to show off! Give our office a call today at [PhoneNumber] to schedule a consultation appointment.#NAME?https://www.dropbox.com/s/5i12vb8id7l5hsd/895082_Social%20Media%20Posts%20December_6D_010821.jpg?dl=0Looking to improve the look of your smile? Ask our team at Julias and Joes Teeth Pull Place about our cosmetic dentistry solutions and get a smile you are proud to show off! Give our office a call today at (905) 616-6316 to schedule a consultation appointment.
9CosmeticCosmetic Dentistry (General)How can cosmetic dentistry improve your smile? At [PracticeName], we custom tailor your treatment plan to achieve the results you want. Give our office a call today at [PhoneNumber] to schedule a consultation and begin the journey towards the smile of your dreams!#NAME?Cosmetic-1.pngHow can cosmetic dentistry improve your smile? At Julias and Joes Teeth Pull Place, we custom tailor your treatment plan to achieve the results you want. Give our office a call today at (905) 616-6316 to schedule a consultation and begin the journey towards the smile of your dreams!
10CosmeticCosmetic Dentistry (General)Our cosmetic treatments at [PracticeName] can be designed to fit your specific goals for your smile. Give us a call today at [PhoneNumber] to schedule a consultation.#NAME?Cosmetic-2png.pngOur cosmetic treatments at Julias and Joes Teeth Pull Place can be designed to fit your specific goals for your smile. Give us a call today at (905) 616-6316 to schedule a consultation.
11CosmeticCosmetic Dentistry (General)Smile confidently again with cosmetic dental treatments from [PracticeName]! Give our office a call today at [PhoneNumber] to learn about the treatments we offer and schedule an appointment.#NAME?Cosmetic-3.pngSmile confidently again with cosmetic dental treatments from Julias and Joes Teeth Pull Place! Give our office a call today at (905) 616-6316 to learn about the treatments we offer and schedule an appointment.
12CosmeticCosmetic Dentistry (General)Love what you see in the mirror! At [PracticeName], we custom tailor our treatment plans to each patient, helping you achieve the cosmetic results you want for your smile! Give our office a call today at [PhoneNumber] to schedule an appointment.#NAME?Cosmetic-4.pngLove what you see in the mirror! At Julias and Joes Teeth Pull Place, we custom tailor our treatment plans to each patient, helping you achieve the cosmetic results you want for your smile! Give our office a call today at (905) 616-6316 to schedule an appointment.
13CosmeticCosmetic Dentistry (General)Whether you want whitening, veneers, or a complete makeover of your smile, [PracticeName] can help you craft a smile you will love showing off! Ready to schedule a consultation? Give our office a call today at [PhoneNumber].#NAME?Cosmetic-5.pngWhether you want whitening, veneers, or a complete makeover of your smile, Julias and Joes Teeth Pull Place can help you craft a smile you will love showing off! Ready to schedule a consultation? Give our office a call today at (905) 616-6316.
14CosmeticCosmetic Dentistry (General)Looking for a cosmetic dentist? At [PracticeName], our team will work with you to help you achieve your goals for your smile. Give our office a call today at [PhoneNumber] to schedule an appointment.#NAME?Cosmetic-6.pngLooking for a cosmetic dentist? At Julias and Joes Teeth Pull Place, our team will work with you to help you achieve your goals for your smile. Give our office a call today at (905) 616-6316 to schedule an appointment.
15CosmeticCosmetic Dentistry (General)We can help you design the smile of your dreams! For quality cosmetic dentistry you can be confident in, give [PracticeName] a call today at [PhoneNumber].#NAME?Cosmetic-7.pngWe can help you design the smile of your dreams! For quality cosmetic dentistry you can be confident in, give Julias and Joes Teeth Pull Place a call today at (905) 616-6316.
16CosmeticCosmetic Dentistry (General)Need a cosmetic dentist? [PracticeName] is your one-stop-shop for all your cosmetic dental needs. Contact us today at [PhoneNumber], and one of our helpful team members will get you in for an appointment.#NAME?Cosmetic-8.pngNeed a cosmetic dentist? Julias and Joes Teeth Pull Place is your one-stop-shop for all your cosmetic dental needs. Contact us today at (905) 616-6316, and one of our helpful team members will get you in for an appointment.
17CosmeticSmile MakeoverLooking to completely transform your smile? With a smile makeover from [PracticeName], we will work with you to craft the smile of your dreams! Call us today at [PhoneNumber] to schedule a consultation.#NAME?https://www.dropbox.com/s/ejutf2w8ax6xk4x/Smile-Makeover-1.png?dl=0Looking to completely transform your smile? With a smile makeover from Julias and Joes Teeth Pull Place, we will work with you to craft the smile of your dreams! Call us today at (905) 616-6316 to schedule a consultation.
18CosmeticSmile MakeoverAt [PracticeName], our smile makeover treatments are custom tailored to each patient's needs and desired results. Contact us today at [PhoneNumber] to start your journey towards the smile you have always dreamed of!#NAME?https://www.dropbox.com/s/5ttw1a037dl2zeh/Smile-Makeover-2.png?dl=0At Julias and Joes Teeth Pull Place, our smile makeover treatments are custom tailored to each patient's needs and desired results. Contact us today at (905) 616-6316 to start your journey towards the smile you have always dreamed of!
19CosmeticSmile MakeoverShow off your smile again! Contact [PracticeName] today at [PhoneNumber] to learn more about our smile makeover treatments.#NAME?https://www.dropbox.com/s/f8hv766ms5be128/Smile-Makeover-4.png?dl=0Show off your smile again! Contact Julias and Joes Teeth Pull Place today at (905) 616-6316 to learn more about our smile makeover treatments.
20CosmeticSmile MakeoverYou should feel proud showing off your smile! At [PracticeName], our smile makeover treatments allow our patients to craft a smile that they can feel confident in. Give our office a call today at [PhoneNumber] to schedule an appointment.#NAME?https://www.dropbox.com/s/rag1146r8khvrow/Smile-Makeover-5.png?dl=0You should feel proud showing off your smile! At Julias and Joes Teeth Pull Place, our smile makeover treatments allow our patients to craft a smile that they can feel confident in. Give our office a call today at (905) 616-6316 to schedule an appointment.
21CosmeticSmile MakeoverMake your dream a reality with smile makeovers from [PracticeName]! Contact us today at [PhoneNumber] to learn more about our available treatment options.#NAME?https://www.dropbox.com/s/rdmeqrznuv44xfh/Smile-Makeover-6.png?dl=0Make your dream a reality with smile makeovers from Julias and Joes Teeth Pull Place! Contact us today at (905) 616-6316 to learn more about our available treatment options.
22CosmeticSmile MakeoverWant to transform you smile drastically? Call our office today at [PhoneNumber] to learn about smile makeovers here at [PracticeName]!#NAME?https://www.dropbox.com/s/mpd6h93fik8qi8g/Smile-Makeover-7.png?dl=0Want to transform you smile drastically? Call our office today at (905) 616-6316 to learn about smile makeovers here at Julias and Joes Teeth Pull Place!
23CosmeticSmile MakeoverAt [PracticeName], we offer customized smile makeovers, helping our patients feel confident showing off their smile! Contact us today at [PhoneNumber] to schedule a consultation.#NAME?https://www.dropbox.com/s/j4acezal090cp59/Smile-Makeover-8.png?dl=0At Julias and Joes Teeth Pull Place, we offer customized smile makeovers, helping our patients feel confident showing off their smile! Contact us today at (905) 616-6316 to schedule a consultation.
24CosmeticSmile MakeoverA smile makeover here at [PracticeName] can be customized to fit your individual needs and get the results you want. If you are interested in learning more about how a smile makeover could improve your smile, contact our office today at [PhoneNumber].#NAME?https://www.dropbox.com/s/qby8gnbftd9du5y/Smile-Makeover-3.png?dl=0A smile makeover here at Julias and Joes Teeth Pull Place can be customized to fit your individual needs and get the results you want. If you are interested in learning more about how a smile makeover could improve your smile, contact our office today at (905) 616-6316.
25CosmeticTeeth WhiteningInterested in professional whitening treatments? Give our office a call today at [PhoneNumber] and ask about our whitening options!#NAME?https://www.dropbox.com/s/qwq6encnhyaquif/Whitening_March-01.jpg?dl=0Interested in professional whitening treatments? Give our office a call today at (905) 616-6316 and ask about our whitening options!
26CosmeticTeeth WhiteningAt [PracticeName], our professional whitening treatments can help you achieve a brighter, whiter smile in a way which is most convenient for you. Call our office today at [PhoneNumber] to schedule an appointment for your next whitening treatment!#NAME?https://www.dropbox.com/s/az2kd5qz68p9h3h/TeethWhitening_April.jpg?dl=0At Julias and Joes Teeth Pull Place, our professional whitening treatments can help you achieve a brighter, whiter smile in a way which is most convenient for you. Call our office today at (905) 616-6316 to schedule an appointment for your next whitening treatment!
27CosmeticTeeth WhiteningWith our professional teeth whitening at [PracticeName], you can get noticably whiter teeth in a way that is convenient to you. Call our office today at [PhoneNumber] to learn about our teeth whitening options. #NAME?https://www.dropbox.com/s/rk9crhncbtw0ym2/1087785_Social%20Media%20Posts%20June%202021_V2_060421.jpg?dl=0With our professional teeth whitening at Julias and Joes Teeth Pull Place, you can get noticably whiter teeth in a way that is convenient to you. Call our office today at (905) 616-6316 to learn about our teeth whitening options.
28CosmeticTeeth WhiteningLooking for high-quality, professional teeth whitening solutions? Give our office a call today at [PhoneNumber] to learn more about our available options and schedule an appointment!#NAME?https://www.dropbox.com/s/c46hs175deg8v64/11.png?dl=0Looking for high-quality, professional teeth whitening solutions? Give our office a call today at (905) 616-6316 to learn more about our available options and schedule an appointment!
29CosmeticTeeth WhiteningAre you dissatisfied with your drug store whitening kit? Get high-quality, drastic results from [PracticeName] with our professional whitening treatments. Call our office today at [PhoneNumber] to learn more about the treatments we offer!#NAME?https://www.dropbox.com/s/r1kctasz7ylgllu/11.jpg?dl=0Are you dissatisfied with your drug store whitening kit? Get high-quality, drastic results from Julias and Joes Teeth Pull Place with our professional whitening treatments. Call our office today at (905) 616-6316 to learn more about the treatments we offer!
30CosmeticTeeth WhiteningAre drug store whitening products not giving you the whitening results you want? With our professional whitening treatments at [PracticeName], you can get the bright, dazzling smile that you want in a manner that is convenient for your lifestyle. Call us today at [PhoneNumber] to schedule an appointment!#NAME?https://www.dropbox.com/s/hv8tsi45c1081n1/4.jpg?dl=0Are drug store whitening products not giving you the whitening results you want? With our professional whitening treatments at Julias and Joes Teeth Pull Place, you can get the bright, dazzling smile that you want in a manner that is convenient for your lifestyle. Call us today at (905) 616-6316 to schedule an appointment!
31CosmeticTeeth WhiteningInterested in high quality, professional whitening? At [PracticeName], our whitening treatments can give you results unmatched by those of drug store whitening kits. Give our office a call today at [PhoneNumber] to schedule an appointment. #NAME?https://www.dropbox.com/s/7222enyl6oeo994/Teeth-Whitening-1.png?dl=0Interested in high quality, professional whitening? At Julias and Joes Teeth Pull Place, our whitening treatments can give you results unmatched by those of drug store whitening kits. Give our office a call today at (905) 616-6316 to schedule an appointment.
32CosmeticTeeth WhiteningAt [PracticeName], we offer many professional whitening options, helping you get a brighter smile in a way that is convenient to you. Give our office a call today at [PhoneNumber] to learn more about our options. #NAME?https://www.dropbox.com/s/bemtyhultj0bl5y/Teeth-Whitening-2.png?dl=0At Julias and Joes Teeth Pull Place, we offer many professional whitening options, helping you get a brighter smile in a way that is convenient to you. Give our office a call today at (905) 616-6316 to learn more about our options.
33CosmeticTeeth WhiteningProfessional whitening treatments from [PracticeName] can deliver results unmatched by any drug store whitening kit! Contact our office today at [PhoneNumber] to schedule your whitening appointment.#NAME?https://www.dropbox.com/s/goeig89iwcnz1k4/Teeth-Whitening-5.png?dl=0Professional whitening treatments from Julias and Joes Teeth Pull Place can deliver results unmatched by any drug store whitening kit! Contact our office today at (905) 616-6316 to schedule your whitening appointment.
34CosmeticTeeth WhiteningIs tooth discoloration making you hide your smile? With whitening treatments at [PracticeName], we can help you get drastic results so you can feel confident showing off your smile! Give our office a call today at [PhoneNumber] to schedule your appointment.#NAME?https://www.dropbox.com/s/5b8pvavu4ep7dac/Teeth-Whitening-6.png?dl=0Is tooth discoloration making you hide your smile? With whitening treatments at Julias and Joes Teeth Pull Place, we can help you get drastic results so you can feel confident showing off your smile! Give our office a call today at (905) 616-6316 to schedule your appointment.
35CosmeticTeeth WhiteningDrug store whitening kits don't stand a chance against our professional whitening treatments here at [PracticeName]! Contact us today at [PhoneNumber] to learn about our whitening options and schedule your appointment.#NAME?https://www.dropbox.com/s/zpux8sw8j1334y7/Teeth-Whitening-7.png?dl=0Drug store whitening kits don't stand a chance against our professional whitening treatments here at Julias and Joes Teeth Pull Place! Contact us today at (905) 616-6316 to learn about our whitening options and schedule your appointment.
36CosmeticTeeth WhiteningLove coffee but not tooth discoloration? With professional whitening treatments from [PracticeName], you can reduce or eliminate discolorations from coffee and other beverages, helping you feel confident showing off your smile! Contact our office today at [PhoneNumber] to schedule an appointment.#NAME?https://www.dropbox.com/s/i6zzna09ndf5bd7/Teeth-Whitening-3%20%281%29.png?dl=0Love coffee but not tooth discoloration? With professional whitening treatments from Julias and Joes Teeth Pull Place, you can reduce or eliminate discolorations from coffee and other beverages, helping you feel confident showing off your smile! Contact our office today at (905) 616-6316 to schedule an appointment.
37CosmeticTeeth WhiteningSmile bright with whitening treatments here at [PracticeName]! Contact us today at [PhoneNumber] and one of our helpful team members will help get you in for an appointment.#NAME?https://www.dropbox.com/s/snkcav205u7hth7/Teeth-Whitening-4.png?dl=0Smile bright with whitening treatments here at Julias and Joes Teeth Pull Place! Contact us today at (905) 616-6316 and one of our helpful team members will help get you in for an appointment.
38CosmeticTeeth WhiteningTooth discoloration can be caused by many things, including diet, smoking, medications, and more. With whitening treatments from [PracticeName], you can drastically improve discoloration of the tooth enamel, reducing or eliminating staining. To schedule your whitening appointement, contact our office today at [PhoneNumber].#NAME?https://www.dropbox.com/s/s15y78m9jfuadcy/Teeth-Whitening-8.png?dl=0Tooth discoloration can be caused by many things, including diet, smoking, medications, and more. With whitening treatments from Julias and Joes Teeth Pull Place, you can drastically improve discoloration of the tooth enamel, reducing or eliminating staining. To schedule your whitening appointement, contact our office today at (905) 616-6316.
ALL DATA
Cell Formulas
RangeFormula
D2:D38D2=IMAGE((SUBSTITUTE(E2,"?dl=0","?dl=1")), 1)
F2:F38F2=SUBSTITUTE(SUBSTITUTE(C2, "[PracticeName]",INPUT!$B$1),"[PhoneNumber]",INPUT!$E$1)



and =INDEX(Table24[Sub Topic],RANDBETWEEN(1,ROWS(Table24[Sub Topic])),1) refers to worksheet input where my drop down is.

Master-Social-Media-Library-Sheet-Separation.xlsx
AB
3TopicSub Topic
4CosmeticSmile Makeover
5OrthoClear Aligners
6PediatricFluoride Treatment
7CosmeticSmile Makeover
8Oral SurgeryExtractions
9MedSpaCellulite Reduction
10EndodonticsRetreatments
11RestorativeDental Bridge
12EndodonticsRoot Canals
13CosmeticTeeth Whitening
14OrthoInvisalign
15PediatricPediatric Dentistry (General)
16CosmeticVeneers
INPUT
Cells with Data Validation
CellAllowCriteria
A4:A16List=TB_Topics
B4:B16List=INDIRECT(SUBSTITUTE(A4," ","_"))
 
Upvote 0
Hi again, forgot to add in my last reply, I almost got the results I wanted, but I need the results to not reappear within the table.
 
Upvote 0
More info
I had found part of my solution in this thread:

However the formula used in there may return duplicates in the column should the data set used be large enough.
 
Upvote 0

Forum statistics

Threads
1,223,948
Messages
6,175,571
Members
452,652
Latest member
eduedu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top