Forum Discussion
Seeking help w/IF statement (or maybe Vlookup/Xlookup?)
Hi, I'm still pretty much a newbie when it comes to Excel, and I wonder if I could ask for help with something. I have a list of several hundred high schools in our area, with multiple columns for a...
=FILTER($A$2:$A$18,B2:B18=1)You can try the FILTER function if you work with Office365 or 2021 or Excel online.
- Thanks so much for the speedy reply! I realized that I should have been more clear - the spreadsheet looks like this, but with many more columns and much more text:
HS name AP classes, pt 1 AP classes, pt 2 Extracurriculars pt 1 Extracurriculars, pat 2
First HS Eng, Comp Sci Calc, Span Chess, Math Robotics, Orch
2nd HS Fre, Hist Phys, Comp Sci Robotics, Art News
....for some reason I couldn't paste the chart in, so I recreated it as best I could. I'm hoping to be able to do this: for HS 1, search multiple columns for "Computer Science" and indicate in a separate column whether that subject is listed; and the same for robotics under extracurriculars, etc. Sorry for not being more clear about that! Is that possible?- Ugh that looks awful and is incomprehensible, sorry. I'll post a new question with a chart that makes sense. Sorry about that!
