|
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 |
Compare 2 lists and return value
On Friday, September 21, 2012 4:28:06 PM UTC-5, KENSONE wrote:
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) |
| All times are GMT +1. The time now is 10:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com