About Us

stnkynts

If it was me I would just run a macro to loop through column "B" as you listed. In the example I submitted it kicks up a message box telling you what the corresponding number value is when it goes above 35.

Code:

Sub FindValue()
Dim rcount As Integer
Dim a As Integer
'gets a count of how many rows there are in column B
rcount = Range("B" & Rows.Count).End(xlUp).Row
'loops through looking for a value greater than 35 in column B
For a = 1 To rcount
    If Range("B" & a)  35 Then
        MsgBox (Range("A" & a))
        Exit Sub
    Else
    End If
Next a
    
End Sub

Let me know if you need help on how to insert or run a macro.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count number of cells until blank cell is reached	Patrick Hourigan	Excel Worksheet Functions	1	August 4th 10 04:00 PM
Inserting the same value until the same value is reached again	Dave F	Excel Discussion (Misc queries)	0	January 19th 07 08:30 PM
Add one until 171 is reached	JP	Excel Worksheet Functions	5	October 16th 06 05:48 PM
Some formula to add results until a given value is reached?	S Davis	Excel Worksheet Functions	1	August 4th 06 06:03 PM
Adding a certain number until minimum is reached	dk	Excel Discussion (Misc queries)	3	December 7th 05 01:29 AM

Menu

About Us