Looking up data

[tomandrobyn]

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

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

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

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

Thanks in advance

 

[Guest]

=INDEX($A$1:$F$6,MATCH(A9,$A$1:$A$6,0)+1,6)

to find the value 1 row down and 5 columns over.

Where your table is in cells A1:F6, the column containing customer numbers
is in cells A1:A6, and cell A9 contains the customer number you want to look
up.

modify the ranges to suit.

 

[tomandrobyn]

Thanks JMB, that does the trick perfectly!

 

[Guest]

you're welcome.