View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KENSONE KENSONE is offline
external usenet poster
 
Posts: 2
Default 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