|OK, I get it.|
What is your search string?
Is it just 35 or is it 35CFM or some other combination of Numbers & Text?
I'm not sure the =VLOOKUP() function is what your looking for.
The syntax of the VLOOKUP() is:
=VLOOKUP( lookup_value , table_array , column_index_num , [range_lookup] )
It is the last section Range_Lookup where the problem lies.
The Range_lookup argument is a logical value (TRUE or FALSE only) that indicates whether you want VLOOKUP to find an exact or an approximate match to the Lookup_value.
If TRUE or if this argument is omitted, VLOOKUP will use an approximate match if it cannot find an exact match to the Lookup_value. If an exact match is not found, VLOOKUP returns the next largest value that is less than the Lookup_value.
If FALSE, VLOOKUP will only use an exact match to the Lookup_value. If there are two or more values in the first column of Table_array that match the Lookup_value, the first value found is used. If an exact match is not found, a #N/A error is returned.
All that being said, what you may need is an INDEX() - MATCH() formula.
=INDEX(Return_value_range, MATCH(Lookup_value, Lookup_value_range, Match_type))
Return_value_range - The range that holds the return values
Lookup_value – The value you want to find in the lookup value array
Lookup_value_range – The range containing lookup values
Match_type – Exact (0), Nearest Greater Than (-1), or Nearest Less Than (1)
If you post a small sample of your data, after reading this HOW-TO which explains the use of the < PRE > tags to keep your data aligned correctly, with Column Letters and Row numbers it would help to give you a more exact answer.
Or, if you want to try on your own, here is a very good tutorial on Index/Match: