Thanks....

All of those will work.

I just thought there may be some combination of hotkeys to calculate it.

For example, if I have the starting column selected then do something like a
cntl-shift and move to the ending column a value may be displayed as to the
number of columns between the 2 marks. Maybe I'm asking for excel to do too
much, but thought it would be a useful set of keys if you do a lot of lookups
like I do.

Thanks for everyones input.

"T. Valko" wrote:

Try something like this:

=COLUMNS($A:A)

$A:A = 1
$A:B = 2
$A:E = 5
$A:J = 10

=VLOOKUP($A1,$B$1:$Z$10,COLUMNS($A:B),0)

As you drag copy across the COLUMNS( ) will increment.

Biff

"stickandrock" wrote in message
...
Is there a way to show the number of columns between 2 columns. Without
using a Column() formula in both then a formula to determine the
difference.

We are constantly using Vlookup at work and end up manually counting
columns
for the desired retreved column.

Thanks for any and all input.