How to search for the content of a cell

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

2 replies

Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
487
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
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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