In general
=COLUMN(AB1)-COLUMN(D1)+1
will give you the index number of Column AB when your data ranges starts at
col D.

If it starts at Col A then you can simply use
=Column(AB1)
since Column(A1) is one

"helpwanted" wrote:

I am using the following formula:

=VLOOKUP($C$2,PKG!A2:BN2000,34,FALSE)

This formula works for columns 1-12. After that, it doesn't give me the
correct information. Is there a way to see the column number to be certain I
am putting the right column number in?