Is your search data sequential and in ordered? If so, a basic LOOKUP
instead of HLOOKUP could accomplish what you want. In a LOOKUP, you
designate different ranges completely so as long as they are the same
size, they can offset as much as you want.
For instance:
=LOOKUP(C3,G1:J1,K5:N5)
The second range is offset by 4 columns and still works...as long as
the data in G1:J1 is ordered.
--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile:
http://www.thecodecage.com/forumz/member.php?userid=73
View this thread:
http://www.thecodecage.com/forumz/sh...ad.php?t=46897