Why not try this instead of Vlookup:

=OFFSET(A1,MATCH(E2,A:A,0)-1,E3)

Where your lookup data is in col A, E2 is the lookup value and E3 is the
column the return value is in. The data table can go as wide as you like
without redifining the formula.

Ernst.


"Budman" wrote:

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.