I'm hoping for some help in pulling information from one sheet onto
another.

For example, I have no problem setting up a vlookup to find a customer
number (happens to be A13) on the other sheet and displaying their name
one column over... =VLOOKUP(A2,Input!A1:F20,2)

What I'm unsure of is how to lookup 2 rows below (so that it displays
what's in A15) or say 1 row down and 5 columns over (F14). I'm guessing
that it may be a vlookup with offset or maybe match?

While the # of columns over and/or rows down from the customer number
will always be the same, the rows that the customer info is on will be
different... for the A13 example, next week it might be on A16 but I'll
still need to lookup one column over, one column down etc. this is why
I'm guessing a vlookup or match might be needed.

Thanks in advance!


--
tomandrobyn
------------------------------------------------------------------------
tomandrobyn's Profile: http://www.excelforum.com/member.php...o&userid=13879
View this thread: http://www.excelforum.com/showthread...hreadid=470056