Previous Topic Next Topic

How to search for the content of a cell

Closed
SamHopps - Mar 9, 2012 at 06:05 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 24, 2012 at 02:36 PM
Hello,

I get sent a stock list by my drop shipper every day, the excel file contains around 6,700 unique product codes, and their stock quantities in a separate column.

However, I only need to know around 350 of these items stock, is there a way I can pullout the product code (from Column A) and its corresponding stock (from Column C) so that I don't have to spend 4hours each morning finding each code by hand?

Thanks a lot,

I look forward to any replies

Sam

Related:

2 responses

Answer 1 / 2
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Mar 19, 2012 at 10:54 AM
Hi Sam,

Is there anything special about those 350 items?

If they are all random then how do you think Excel can assist you?

Best regards,
Trowa
Answer 2 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 24, 2012 at 02:36 PM
Have on one sheet your 350 product (lets say this sheet name is MY_STOCKS and data is in column A)

on the other sheet, on a blank column use formula to find out if the stock listed in MY_STOCK sheet is present or not 

=IF(ISERROR(MATCH(A1,MY_STOCKS!A:A,0)),"Not Present", "Present")


Then you can filter on "Present". These are the lines you were interested in