Hi

if you'ld like to let MS know what you think email them at


with Excel in the subject line and your ideas / reasons in the message body.

BTW i never use full columns in my VLOOKUP ranges, more often than not i'll
use a dynamic range name for the table array - then i don't have to redefine
the number of columns / rows - it can do it itself.
Check out www.contextures.com/tiptech.html on how to create dynamic range
names if this is new to you

Cheers
JulieD

"Budman" wrote in message
...
When using Vlookup, the function asks for a table array. I'd like to
suggest
a change to the function. Provide a one column range, then allow the
function
to find it ## rows over. For example,

instead of: =Vlookup(A1,C:G,5,false)
simply: =Vlookup(A1,C:C,5,false)

This may seem minor, but when you're doing a lot of reference work in one
spreadsheet, the current function requirements are fairly time consuming.