Checkbox Issues with VLOOKUP
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
[link] [comments]
Want to read more?
Check out the full article on the original site