View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
 
Posts: 1,522
Default Help! Is this possible

On Friday, September 21, 2012 4:04:53 PM UTC-5, KENSONE wrote:
Can someone help me with this? I have two lists on the same sheet. The

first list 60,000 rows use column A, B, C, D, E, F (ID, Desc, Price,

Etc) The second list 300 rows column K and L (ID, Desc). What I would

like to do is find the value in column K (ID) within column A (ID) and

then return the price in column E (price). So if the ID in list 2 is

found somewhere in list 1 I would get the price as the return value.

Not sure if im making sense but hopefully someone understands. Thanks

in advance





List 1 List 2

Price

1234, Beer, $3.00 2134, Food $10.00

1235, Beef, $7.00 2135, Retail

2134, Food, $10.00