Complicated V-lookup

B

Big Ben

I need to do a lookup on the following info (Note: the dots are no
present on the spreadsheet, and also the spreadsheet is much mor
complicated than this, I have just simplfied it): I need somethin
that will lookup the dealer # go over 2 columns, and then down
columns....any Help would be great!!!

Dealer # 85113.... No. Cashed......5
.............................. No. Apps........10
.............................. Percentage....50%

Dealer # 85114......No. Cashed......7
...............................No. Apps........14
...............................Percentage....50%


I would like the info to appear as follows:

Dealer #.........Percentage
85113..................50%
85114..................50
 
P

Paul Corrado

=OFFSET(A1,MATCH("dealer#",A1:A10,0)+2,2)

Adjust the A1 to be the first cell in your range of dealer information, and
adjust the A1:A10 range as needed.
 
D

Domenic

Assumptions...

Column A contains your dealer numbers
Column B contains related data
First row contains your labels
Data starts on the second row
Each record consists of three rows
Records are separated by one blank row

=OFFSET($A$2,MATCH(D2,$A$2:$A$100,0)+1,1)

...where D2 contains the deal number of interest.

If you have a list of dealer numbers down a column, let's say Column
starting at D2, and you want the formula to return the results for eac
one of them, then enter the formula in E2 and copy down.

Hope this helps
 
Top