Hello, I was wondering if there was a way to search a single number included in an input range? For example, in a spreadsheet a user inputs a model number in column A and a range of serial numbers in column B (see table below).
[cid:image001.png@01D8EED9.DEA88690] Is there a way to set up the spreadsheet so that the user can search, for example, serial number 1150 and the program will flag row 2 where the searched serial number falls into the input range in column B? The ctrl+F and the other search features in the program seem to only be able to find numbers that appear as text in the document (in the image above, the search feature would only recognize 1100 and 1200, but none of the number in between). Is there perhaps a way to format the cells in column B as "ranges" so that the program would be able to recognize all of the numbers in the range without having to enter each individual serial number? Thank you for your help, Lauren Haynes Electro-Mechanical Manufacturing Engineer [cid:image002.jpg@01D8EED9.DEA88690] Steiner eOptics 3475 Newmark Drive Miamisburg, OH 45342 USA lhay...@steiner-eoptics.com<mailto:lhay...@steiner-eoptics.com> www.steiner-defense.com<http://www.steiner-defense.com/> Office (937) 490-2519 Mobile (513) 910-2969 U.S. Export Control Warning "This email and attachment(s), if any, may contain technical data or information subject to controls and restrictions including, but not limited to the International Traffic in Arms Regulations (ITAR), the Export Administration Regulations (EAR), or the Office of Foreign Assets Control. Transfer of such data or information by any means to a non-US person, whether in the United States or abroad, without proper authorization or approval from the US Department of State, Department of Commerce, or other appropriate US Government Agency, as applicable, is prohibited." Confidentiality / Proprietary Information: The contents of the this email are Confidential and Proprietary to Steiner eOptics, Inc. If you are not the intended recipient, or believe that you have received this communication in error, please do not print, copy, transmit, disseminate, or otherwise use the information. Please indicate to the sender that you have received this e-mail in error, and delete the copy you received.
