Hi,

Does anyone know how to use the offset (or vlookup) to capture a range for
use in a LOOKUP function?
My lookup function looks like:

=LOOKUP(A20,C1:I1,Q1:W1)

whe

the C1:I1 is the reference range for a particular customer; and
Q1:W1 is the result range for a particular customer.

I want to be able to reference both these ranges (1 row; 7 columns) base on
a vlookup (or offset) from my list of customer names.

Is there a way to do this?

I have a prepared xls example if anyone has the time to help.

thanks

Elijah