Checkbox Issues with VLOOKUP

Our take

If you're working on a spreadsheet for Pokémon TCG cards and facing issues with VLOOKUP when adding new sets, you're not alone. You want to ensure that checkboxes tick correctly based on the Pokémon names in your new columns, allowing you to track how many sets include each Pokémon. It sounds like your current formula is returning N/A, despite the expected matches. Let’s explore how to refine your approach to ensure accurate lookups and effective counting for your card sets.

Hey guys! I'm in need of some quick help potentially, I'm in the process of completing a spreadsheet for the full list of PKMN TCG cards from the sets.

I have a full list of the Pokemon and the # numbers and to the right of the format is the sets themselves.

What I want to happen is when I enter in a new set, the formatted spreadsheet will lookup the PKMN name in this new column and tick the checkbox, as I've got a COUNTIF on all of PKMN so I can find out exactly how many are in each set and also how many sets include said PKMN

Whenever I copy the formula over to the next column for the set it just shows N/A even though I know there's one in the set.

=IF(VLOOKUP("*"&D3,EZ3:KE250,1,FALSE)=D3,"☑️","☐")

D3 is the PKMN name

EZ3:KE250 is the range of the sets with the list of PKMN

https://preview.redd.it/pvtwcyr9fyxg1.png?width=2451&format=png&auto=webp&s=71d2471ed1a4a9b49103450e689391c7f479c1b4

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

Read on the original site

Open the publisher's page for the full experience

View original article →

Tagged with

#Excel alternatives for data analysis#natural language processing for spreadsheets#modern spreadsheet innovations#machine learning in spreadsheet applications#generative AI for data analysis#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#collaborative spreadsheet tools#AI-driven spreadsheet solutions#cloud-based spreadsheet applications#automation in spreadsheet workflows#no-code spreadsheet solutions#AI-powered spreadsheet#spreadsheet API integration#rows.com#financial modeling with spreadsheets#AI formula generation techniques#Excel compatibility#formula generator#Excel alternatives