Is there a way to do a VLOOKUP on a hidden sheet? I have a value stored in a vaiable called, "MatlNumber" and I would like to know if it is in column A of a sheet tab called "ChkItemCatG". If it is there? store a "Yes" in a variable called Exclusion, if vlookup is false store a No in a variable called NoExclusion. Issue is that I would like to hide the sheet tab called "ChkItemCatG".
How would this look in vba and is it even possible to do this on a hidden sheet? Please advise and thanks.