Just to warn you guys, bit of a Yu-Gi-Oh nerd for 1, 2 i love organizing, and 3 never delved this far into excel until recently.
With that being said...
I've just been trying to organize an entire column to change its name due to the first 3-4 text on a card, and it represents the set it belongs to.
For Example, SDB-008, it only grabs the text SDB to then insert in the cell "Structure Deck: Saga of Blue-Eyes White Dragon"
Essentially i hit a roadblock where i want to try to add one more of these to the formula but it just won't let me. (I guess i hit the limit here with this long and complicatedly specific formula)
I've tried to use the "&" between IFS and it only shows N/A instead of the formula i want to add on to this string.
I've also been trying to find answers on how to take data from a cell and apply it to another one. (With Helper Columns)
For Example: Instead of just using B2 i could use X2 to simulate as if its B2 and still insert data into B2 as if its still B2. (I've also been trying to figure out on how to do this on another sheet and sent the data from one sheet to another and back to the original)
So yeah, i feel like im thinking too hard and there is an easy simple solution; been trying to figure this out and find any answer possible for about a solid week now.
(Decided to use this forum as a way to get an answer since it seems like a wonderful community, i just made this account recently because of the informed people here)
Anyways, if anyone can figure this crap out, id be more than happy to give you my time; also if im just being ridiculous let me know lol
Thank you guys and stay awesome!
=IFS(ISNUMBER(SEARCH("SDB",$B2)),"Structure Deck: Saga of Blue-Eyes White Dragon",ISNUMBER(SEARCH("SKE",$B2)),"Starter Deck: Kaiba Evolution",ISNUMBER(SEARCH("DUPO",$B2)),"Duel Power",ISNUMBER(SEARCH("DRL2",$B2)),"Dragons of Legend 2",ISNUMBER(SEARCH("TOCH",$B2)),"Toon Chaos",ISNUMBER(SEARCH("LOB",$B2)),"Legend of Blue Eyes White Dragon",ISNUMBER(SEARCH("MVP1",$B2)),"Yu-Gi-Oh! The Dark Side of Dimensions Movie Pack Secret Edition",ISNUMBER(SEARCH("DUOV",$B2)),"Duel Overload",ISNUMBER(SEARCH("ETCO",$B2)),"Eternity Code",ISNUMBER(SEARCH("LDS1",$B2)),"Legendary Duelists: Season 1",ISNUMBER(SEARCH("SESL",$B2)),"Secret Slayers",ISNUMBER(SEARCH("MP18",$B2)),"Extreme Force",ISNUMBER(SEARCH("FUEN",$B2)),"Fusion Enforcers",ISNUMBER(SEARCH("CIBR",$B2)),"Circuit Break",ISNUMBER(SEARCH(" DP2",$B2)),"Duelist Pack: Chazz Princeton",ISNUMBER(SEARCH("LCYW",$B2)),"Legendary Collection 3: Yugi's World Mega Pack",ISNUMBER(SEARCH("CBLZ",$B2)),"Cosmo Blazer",ISNUMBER(SEARCH("CHIM",$B2)),"Chaos Impact",ISNUMBER(SEARCH("CT14",$B2)),"2017 Mega Tins",ISNUMBER(SEARCH("IOC",$B2)),"Invasion of Chaos",ISNUMBER(SEARCH("SAST",$B2)),"Savage Strike",ISNUMBER(SEARCH("MIL1",$B2)),"Millenium Pack",ISNUMBER(SEARCH("FLOD",$B2)),"Flames of Destruction",ISNUMBER(SEARCH("MRL",$B2)),"Spell Ruler",ISNUMBER(SEARCH("MRD",$B2)),"Metal Raiders",ISNUMBER(SEARCH("LON",$B2)),"Labyrinth of Nightmare",ISNUMBER(SEARCH("PSV",$B2)),"Pharaoh's Servant",ISNUMBER(SEARCH("RGBT",$B2)),"Raging Battle",ISNUMBER(SEARCH("SBCB",$B2)),"Speed Duel: Battle City Box",ISNUMBER(SEARCH("MAGO",$B2)),"Maximum Gold",ISNUMBER(SEARCH("LED7",$B2)),"Legendary Duelists: Rage of Ra",ISNUMBER(SEARCH("PHRA",$B2)),"Phantom Rage",ISNUMBER(SEARCH("GEIM",$B2)),"Genesis Impact",ISNUMBER(SEARCH("SDJ",$B2)),"Starter Deck: Joey",ISNUMBER(SEARCH("SYE",$B2)),"Starter Deck: Yugi Evolution",ISNUMBER(SEARCH("SDY",$B2)),"Starter Deck: Yugi",ISNUMBER(SEARCH("DR1",$B2)),"Dark Revelation Volume 1",ISNUMBER(SEARCH("LOD-",$B2)),"Legacy of Darkness",ISNUMBER(SEARCH("AST",$B2)),"Ancient Sanctuary",ISNUMBER(SEARCH("BLAR",$B2)),"Battles of Legend: Armageddon",ISNUMBER(SEARCH("BLRR",$B2)),"Battles of Legend: Relentless Revenge",ISNUMBER(SEARCH("CT1",$B2)),"2004 Collectors Tin",ISNUMBER(SEARCH("DB1",$B2)),"Dark Beginning 1",ISNUMBER(SEARCH("DCR",$B2)),"Dark Crisis",ISNUMBER(SEARCH("DPRP",$B2)),"Duelist Pack: Rivals of the Pharaoh",ISNUMBER(SEARCH("EDS",$B2)),"Eternal Duelist Soul",ISNUMBER(SEARCH("EEN",$B2)),"Elemental Energy",ISNUMBER(SEARCH("FET",$B2)),"Flaming Eternity",ISNUMBER(SEARCH("MBD",$B2)),"Meteor Black Dragon",ISNUMBER(SEARCH("MFC",$B2)),"Magician's Force",ISNUMBER(SEARCH("MP20",$B2)),"2020 Mega Tin: Lost Memories",ISNUMBER(SEARCH("MOV",$B2)),"Movie Pack",ISNUMBER(SEARCH("PGD",$B2)),"Pharaonic Guardian",ISNUMBER(SEARCH("POTD",$B2)),"Power of the Duelist",ISNUMBER(SEARCH("RDS",$B2)),"Rise of Destiny",ISNUMBER(SEARCH("ROTD",$B2)),"Rise of the Duelist",ISNUMBER(SEARCH("SD2",$B2)),"Structure Deck: Zombie Madness",ISNUMBER(SEARCH("SD3",$B2)),"Structure Deck: Blaze of Destruction",ISNUMBER(SEARCH("SD4",$B2)),"Structure Deck: Fury from the Deep",ISNUMBER(SEARCH("SD5",$B2)),"Structure Deck: Warrior's Triumph",ISNUMBER(SEARCH("SD6",$B2)),"Structure Deck: Spellcaster's Judgement",ISNUMBER(SEARCH("SD7",$B2)),"Structure Deck: Invincible Fortress",ISNUMBER(SEARCH("SD8",$B2)),"Structure Deck: Lord of the Storm",ISNUMBER(SEARCH("SDK",$B2)),"Starter Deck: Kaiba",ISNUMBER(SEARCH(" SDP",$B2)),"Starter Deck: Pegasus",ISNUMBER(SEARCH("SOD",$B2)),"Soul of the Duelist",ISNUMBER(SEARCH("SOI",$B2)),"Shadow of Infinity",ISNUMBER(SEARCH("SRL",$B2)),"Spell Ruler",ISNUMBER(SEARCH("STON",$B2)),"Strike of Neos",ISNUMBER(SEARCH("TP5",$B2)),"Tournament Pack 5",ISNUMBER(SEARCH("YSD",$B2)),"Starter Deck 2006",ISNUMBER(SEARCH("HA01",$B2)),"Hidden Arsenal",ISNUMBER(SEARCH("MP14",$B2)),"2014 Mega-Tin Mega Pack",ISNUMBER(SEARCH("SDCL",$B2)),"Structure Deck: Cyberse Link",ISNUMBER(SEARCH("YS17",$B2)),"Starter Deck: Link Strike",ISNUMBER(SEARCH("DUSA",$B2)),"Duelist Saga",ISNUMBER(SEARCH("TFK",$B2)),"Yu-Gi-Oh! The Falsebound Kingdom Promotional Cards",ISNUMBER(SEARCH("MACR",$B2)),"Maximum Crisis",ISNUMBER(SEARCH("PCY",$B2)),"Yu-Gi-Oh! Power of Chaos: Yugi the Destiny Promotional Cards",ISNUMBER(SEARCH("DP1",$B2)),"Duelist Pack: Jaden Yuki",ISNUMBER(SEARCH("LEDD",$B2)),"Legendary Dragon Decks",ISNUMBER(SEARCH("KACB",$B2)),"Kaiba's Collector Box",ISNUMBER(SEARCH("PP01",$B2)),"Premium Pack",ISNUMBER(SEARCH("MP17",$B2)),"2017 Mega-Tin Mega Pack",ISNUMBER(SEARCH("RATE",$B2)),"Raging Tempest",ISNUMBER(SEARCH("5DS1",$B2)),"Starter Deck: Yu-Gi-Oh! 5D's",ISNUMBER(SEARCH("JUMP",$B2)),"Shonen Jump Vol. 10, Issue 4 Promotional Card",ISNUMBER(SEARCH("LOD2",$B2)),"Yu-Gi-Oh! Legacy of the Duelist: Link Evolution Promotional Cards",ISNUMBER(SEARCH("SP1",$B2)),"Cybernetic Revolution Sneak Peek Participation Card",ISNUMBER(SEARCH("DPCT",$B2)),"Duelist Pack Collection Tin 2010",ISNUMBER(SEARCH("YGLD",$B2)),"Yugi's Legendary Decks",ISNUMBER(SEARCH("CMC",$B2)),"Yu-Gi-Oh! Capsule Monster Coliseum Promotional Cards",ISNUMBER(SEARCH("WC09",$B2)),"Yu-Gi-Oh! 5D's Stardust Accelerator Promotional Cards",ISNUMBER(SEARCH("LEDU",$B2)),"Legendary Duelists",ISNUMBER(SEARCH("PP02",$B2)),"Premium Pack 2",ISNUMBER(SEARCH("MDP2",$B2)),"McDonald's Promotional Cards 2",ISNUMBER(SEARCH("DP04",$B2)),"Duelist Pack: Zane Truesdale",ISNUMBER(SEARCH("HA05",$B2)),"Hidden Arsenal 5: Steelswarm Invasion",ISNUMBER(SEARCH("SDPD",$B2)),"Pendulum Domination Structure Deck",ISNUMBER(SEARCH("SDDL",$B2)),"Dragunity Legion Structure Deck ",ISNUMBER(SEARCH("THSF",$B2)),"The Secret Forces",ISNUMBER(SEARCH("SECE",$B2)),"Secrets of Eternity",ISNUMBER(SEARCH("ABYR",$B2)),"Abyss Rising",ISNUMBER(SEARCH("RYMP",$B2)),"Ra Yellow Mega Pack",ISNUMBER(SEARCH("NKRT",$B2)),"Noble Knights of the Round Table Box Set",ISNUMBER(SEARCH("YS14",$B2)),"Space-Time Showdown Power-Up Pack",ISNUMBER(SEARCH("DB2",$B2)),"Dark Beginning 2",ISNUMBER(SEARCH("TLM",$B2)),"The Lost Millennium",ISNUMBER(SEARCH("DBT",$B2)),"Yu-Gi-Oh! Destiny Board Traveler Promotional Cards",ISNUMBER(SEARCH("SDDE",$B2)),"The Dark Emperor Structure Deck",ISNUMBER(SEARCH("SDDC",$B2)),"Dragons Collide Structure Deck",ISNUMBER(SEARCH("SHSP",$B2)),"Shadow Specters",ISNUMBER(SEARCH("SDLI",$B2)),"Realm of Light Structure Deck",ISNUMBER(SEARCH("CT07",$B2)),"Collectible Tins 2010 Wave 1",ISNUMBER(SEARCH("EOJ",$B2)),"Enemy of Justice",ISNUMBER(SEARCH("CRMS",$B2)),"Crimson Crisis",ISNUMBER(SEARCH("ORCS",$B2)),"Order of Chaos",ISNUMBER(SEARCH("GLAS",$B2)),"Gladiator's Assault",ISNUMBER(SEARCH("SDMA",$B2)),"Structure Deck: Marik",ISNUMBER(SEARCH("SD1",$B2)),"Structure Deck: Dragon's Roar ",ISNUMBER(SEARCH("EP1",$B2)),"Exclusive Pack",ISNUMBER(SEARCH("PHSW",$B2)),"Photon Shockwave",ISNUMBER(SEARCH("HA04",$B2)),"Hidden Arsenal 4: Trishula's Triumph",ISNUMBER(SEARCH("HA02",$B2)),"Hidden Arsenal 2",ISNUMBER(SEARCH("GLD4",$B2)),"Gold Series 4: Pyramids Edition",ISNUMBER(SEARCH("TDGS-",$B2)),"The Duelist Genesis",ISNUMBER(SEARCH("LODT-",$B2)),"Light of Destruction")
Bookmarks