1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Trying to Find a Formula: If Text in X is Y, then have Z Text, Otherwise Leave Blank?

Our take

Are you looking to streamline your spreadsheet with a formula that automatically populates mascot and logo texts based on text input? If the text in a specific column matches either DeLaSalle or Cooper, you can easily set up a formula that displays the corresponding mascot and logo file names. This approach not only enhances your data management but also simplifies your workflow by eliminating manual entries. Let’s explore how to create this formula for a more efficient and organized spreadsheet experience.

I'm trying to figure out a formula to do this. If there is text in the Column after the sport, based on that I'd like to have the Mascot and Logo Texts populate in automatically. There are two possibilities. DeLaSalle and Cooper; each has their own mascot and logo file name respectively.

https://preview.redd.it/k3p6d3sgwyxg1.jpg?width=764&format=pjpg&auto=webp&s=a4eab6c56e7c837a9b0d2a3ed7494f1a03ec21d0

submitted by /u/DrZurn
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article

Tagged with

#AI formula generation techniques#rows.com#formula generator#Excel compatibility#cloud-based spreadsheet applications#Excel alternatives for data analysis#Excel alternatives#formula#mascot#logo#text#DeLaSalle#Cooper#populate#sport#column#file name#automatically#sport text#possibilities