|Well, before I even try to figure out what your goal is, I can say straight off that your VLOOKUP formula is incorrect:|
VLOOKUP(A3, Products!B:B, 2, FALSE)
Your table_array consists of a single column (B) yet you are asking the formula to return the value from the second column (2).
Keep in mind that the col_index_num argument of VLOOKUP refers to the column number of the table_array, not the column number of the sheet.
If you want to return the value from column 2 of the table_array, then you need to reference at least 2 columns:
VLOOKUP(A3, Products!B:C, 2, FALSE)
That formula says that A3 is the value to be found in Products Column B and the corresponding value from Products Column C should be returned.
If you are simply trying to see if A3 is found in Products Column B, then your col_index_num should be 1:
VLOOKUP(A3, Products!B:B, 1, FALSE)
Does that information help resolve whatever your problem is?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.