worksheet function help

  • Thread starter Thread starter Jambruins
  • Start date Start date
J

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
 
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'
 
Back
Top