Help! This Vlookup is Driving Me Crazy.
I'm loosing mind with
this vlookup and don't know if I should use an index/match. However, I have one sheet whereas I'm trying to prefill the 'Copy Ready' cells with yes or no based on if the value is found in another sheet and if in that same row where the value is found it's checked off as true under a column named "Web Ops ready". Attached are images of my spreadsheets and I was able to get it to work when the value is found; however,when the value isn't found it say "#NO MATCH." So I tried to wrap my vlookup in an IFERROR and now it says no for the matches. PLEASE HELP. I'm loosing my mind over this one. Thanks in advance.
Help Article Resources
Check out the Formula Handbook template!