Merging text from one cell into a formula in another
I'm not sure if there's an easier way to explain this but here goes.
I'm building a spreadsheet for Pokémon cards as I'm making the placeholders for binders that are on Etsy.
The lists of cards are on a separate sheet for each set and then I have a main table for the entire list of sets with a numerical tally of how many of each Pokémon there is.
What I'm trying to accomplish is, if there's anyway I can just type the set name into one cell and it uses that value in the below formula to find that Pokémon within the set, as per example.
As you can see it shows the formula but that's copied from the column to the left, I need it to somehow change the 'Stellar Miracle.....'! into whatever I type into the title box but keeping the cell references ($P$7 etc). This copying and pasting, then altering the name manually is very time consuming
[link] [comments]
Want to read more?
Check out the full article on the original site