search certain part of cell

[Jewelzzz00]

http://lh3.ggpht.com/_caK9XMuXnSw/S2m3s9teApI/AAAAAAAACtI/XIU7LTqAzdg/s800/SCREENSHOT.JPG

<a href="http://picasaweb.google.com/lh/photo/A8A7SWGnHkpqFZaUnjxIXw?authkey=Gv1sRgCJbSs4a3h7PnRw&feat=embedwebsite"><img src="http://lh3.ggpht.com/_caK9XMuXnSw/S2m3s9teApI/AAAAAAAACtI/XIU7LTqAzdg/s800/SCREENSHOT.JPG" /></a>

i have a array table

all the rows of data get a unique file number , no duplicates.

the file number format is 1.01, or 241.00, or 5132.03,etc.

all numbers to the left of the period symbol are "file info" reference
all numbers to the right of the period symbol are "bills" found inside the file #.
there can be any amount of file #'s, always starting from 1 thru as many as there can be (apprx. thousands of files). and the bills can be from .00 thru .99

my search field ($r$9), need to search or find only the exact match to the left of the period.

NEED to search for file 1, i need the array table to kick back only the file numbers 1.01 and 1.65, not 241.00 not 3.01.

how can i search only the text before the period to the left and exactly what is entered into my search box??

please help.

 

[Jewelzzz00]

thank you so much ,
i have been messing with this for 2 days. i m a newbie , and would never would have know to insert those symbols, to isolate the integers.

many thankz , and hope this helps people in the future.



solution

=IFERROR(INDEX(FILENUM,SMALL(IF(ISNUMBER(SEARCH("|"&INT(FILENUM)&"|","|"&$R$9&"|")),ROW(FILENUM)-MIN(ROW(FILENUM))+1,""),ROW(FILENUM)-MIN(ROW(FILENUM))+1),COLUMN(FILENUM)-MIN(COLUMN(FILENUM))+1),"")