I would like to pull back all the columns that match the lookup_value by
copying and pasting the VLOOKUP formula, but the column_index_num stays
the same. Instead of changing the column_index_num manually in each
cell is there a formula or value that will increase it by 1 when I drag
the formula to the adjacent cells?

=VLOOKUP(A2,Products!$A$2:$Z$100,2,FALSE)
=VLOOKUP(A2,Products!$A$2:$Z$100,3,FALSE)
=VLOOKUP(A2,Products!$A$2:$Z$100,4,FALSE)
=VLOOKUP(A2,Products!$A$2:$Z$100,5,FALSE)

Thanks for the help.

Mike