Compare 2 lists and return value
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
|