Search through a String of Values for a certain Input

%3CLINGO-SUB%20id%3D%22lingo-sub-2261548%22%20slang%3D%22en-US%22%3ESearch%20through%20a%20String%20of%20Values%20for%20a%20certain%20Input%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2261548%22%20slang%3D%22en-US%22%3E%3CP%3EFor%20this%20situation%2C%20I%20am%20given%20an%20input%20value%20much%20larger%20than%20the%20value%20I%20am%20looking%20for.%20I%20have%20a%20row%20of%20item%20numbers%20that%20correspond%20to%20an%20item.%20I%20need%20to%20be%20able%20to%20input%20a%20value%20and%20have%20it%20reciprocate%20the%20horizontal%20item%20pertaining%20to%20the%20item%20number.%20For%20example%2C%20if%20I%20have%20an%20input%20value%20of%20%221239999123%2C%22%20I%20need%20to%20search%20through%20the%20item%20number%20column%20for%20%229999%2C%22%20which%20is%20contained%20within%20the%20larger%20input%20value.%20The%20only%20solution%20I%20have%20seen%20is%20when%20I%20input%20a%20smaller%20amount%20of%20characters%20and%20relate%20it%20to%20a%20larger%20amount%20of%20characters%2C%20such%20as%20searching%20for%20%221%22%20in%20%221%202%203.%22%20In%20this%20situation%2C%20I%20need%20the%20opposite.%20I%20have%20attached%20the%20excel%20file%20below.%20Any%20help%20would%20be%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

For this situation, I am given an input value much larger than the value I am looking for. I have a row of item numbers that correspond to an item. I need to be able to input a value and have it reciprocate the horizontal item pertaining to the item number. For example, if I have an input value of "1239999123," I need to search through the item number column for "9999," which is contained within the larger input value. The only solution I have seen is when I input a smaller amount of characters and relate it to a larger amount of characters, such as searching for "1" in "1 2 3." In this situation, I need the opposite. I have attached the excel file below. Any help would be appreciated.

0 Replies