worksheet function help

[Jambruins]

I have two columns (A and B). Column A has the following in it.
0+00
0+01
0+02
This goes up to 30+50. Column B has the following in it.
164.98
165.00
165.78
These correspond to the numbers in column A. I want to find all th
numbers in column A that correspond to 164.00, 165.00, 166.00, etc.

How would I set up a formula to do this? Something like if column B
166.00 then enter column A.

Thank

 

[Frank Kabel]

Hi
how do you want your result displayed?
- separate table
- in a different column

For just getting the first occurence you may use something like
=INDEX(A1:A100,MATCH(164.0,B1:B100,0))

Or you may use 'Data - Filter - Autofilter'