I would like to pull data into one column based on what is chosen in the previous column. Column "A" contains a list. Each item in that list represents another list. I'd like the field for the child list to be displayed in column "B". I'm trying IF statements but the text editor is getting really slow when I add more than two statements. Would CASE even work for this? Or is there another approach to use? Byron Nash INSP, LLC.
