Compare 2 lists and return value

[KENSONE]

What I would like to do is find the value in column K within column A
and return the price in column D. Can someone help me out with this?
Thanks in advance



List 1

A B C D
5015295
SHRIMP NACHOS
$3.89
$14.50
5015296
STEAK NACHOS
$3.38
$14.00
5015297
CALAMARI NACHOS
$3.83
$13.50
5015304
CAB-CHEESE NACHOS
$2.24
$10.00
5015305
CAB-CHICKEN NACHOS
$3.39
$13.00


List 2

K L
5015293
CHEESE NACHOS
5015294
CHICKEN NACHOS
5015295
SHRIMP NACHOS
5015296
STEAK NACHOS


Return Value
K L M
5015293
CHEESE NACHOS

5015294
CHICKEN NACHOS

5015295
SHRIMP NACHOS
14.50
5015296
STEAK NACHOS
14.00

 

[Don Guillett]

What I would like to do is find the value in column K within column A

and return the price in column D. Can someone help me out with this?

Thanks in advance







List 1



A B C D

5015295

SHRIMP NACHOS

$3.89

$14.50

5015296

STEAK NACHOS

$3.38

$14.00

5015297

CALAMARI NACHOS

$3.83

$13.50

5015304

CAB-CHEESE NACHOS

$2.24

$10.00

5015305

CAB-CHICKEN NACHOS

$3.39

$13.00





List 2



K L

5015293

CHEESE NACHOS

5015294

CHICKEN NACHOS

5015295

SHRIMP NACHOS

5015296

STEAK NACHOS





Return Value

K L M

5015293

CHEESE NACHOS



5015294

CHICKEN NACHOS



5015295

SHRIMP NACHOS

14.50

5015296

STEAK NACHOS

14.00

Look in the help index for MATCH and then INDEX then use the match result within the index formula
index(column, matchvalue)

 

[pclive]

Maybe this:

=INDEX($D$2:$D$6,MATCH(K2,$A$2:$A$6,0))

But that's pretty much what Don was saying.