"shelly2" wrote in
message ...

I use the Vlookup a lot and sometimes in some very large spreadsheets.
As you can imagine I spend a lot of time counting columns to find the
column index number. Is there a formula I can use that will do that
counting for me? For example if my lookup value is in column A and my
return value is in column C the answer for this formula should be 3.

Tools/ Options/ General/ R1C1 reference style
will give the columns numbers, rather than letters.
--
David Biddulph