Looking up data
 

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

=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" wrote:


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

Thanks JMB, that does the trick perfectly!


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

you're welcome.

"tomandrobyn" wrote:


Thanks JMB, that does the trick perfectly!


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