If you are dragging it across

=VLOOKUP(A2,Products!$A$2:$Z$100,COLUMN(B1),FALSE)


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Mike C" wrote in message
...
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