INDEX?

[Dennis]

I would like to fill points after a NASCAR race for a pool we have at work
by bringing the points from L to B and D.
So to use B2 as my example, I would like to take A2, search thru column
K and find the match(which is Jeff Gordon in K13), take the points for him in
L13(170) and put them in B2. I think it's using the INDEX and MATCH
but I'm just not getting it right.


A B C D

2 Jeff Gordon 0 Dale Earnhardt 0
3 Jimmie Johnson 0 Jeff Gordon 0
4 Bobby Labonte 0 Jimmie Johnson 0
5 Terry Labonte 0 Kasey Kahne 0
6 Tony Stewart 0 Ryan Newman 0



K L

11 Elliott Sadler 185
12 Kasey Kahne 180
13 Jeff Gordon 170
14 Dale Earnhardt Jr. 165
15 Rusty Wallace 160
16 Kurt Busch 155


TIA,
Dennis
===========

 

[Frank Kabel]

Hi
try the following in B2
=VLOOKUP(A2,$K$11:$L$20,2,0)

 

[Vasant Nanavati]

Try:

=INDIRECT("L"&MATCH($A2,K$1:K$100,0))

 

[Dennis]

Thanx to you and to Frank!!!
Very appreciated. I always try to make it harder than it is.

Dennis
===========