Open Office Search Question

[Lauren Haynes <lh...@steiner-eoptics.com.INVALID>]

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

lhaynes@steiner-eoptics.com<ma...@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.