how to search for the content of a cell Closed

Question

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

Configuration: Windows Vista / Safari 535.11

TrowaD · Answer

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

rizvisa1 · Answer

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

How to search for the content of a cell

2 responses

Similar discussions

Subscribe To Our Newsletter!