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

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

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

Please post a MEANINGFUL subject line