Hello,
I used conditional IF to write my formulas but when my table increase in size, it became many IF statements in a cell.
I tried to replace IF with lookup function but some how I got so many ERR.
Can someone write me the formulas to solve my issue?
Here is the example:
It can be a row or column but let assume it is a row A1, B1, C1, etc.
Ie. A1 = -25, B1 = 0, and C1 = 31.
We have another row consist of A7 to AA7 for example.
Now we want to search through A7 to AA7 to find a value between A1 and B1(between -25 to 0), B1 and C1 (between 0 to 31) etc...
If it does found, it will display the found value in a cell in question.
Thanks.
Configuration: Windows XP Firefox 3.0.5
You did not give complete informational. If a cell in range A1:AA77 is between A1 and B1 what should I do
Sub test()
Dim rng As Range, c As Range, rng1 As Range, c1 As Range
Dim x1, x2
With Worksheets("sheet1")
Set rng = Range(.Range("a1"), .Range("a1").End(xlToRight)).Offset(0, -1)
For Each c In rng
x1 = c.Value
x2 = c.Offset(0, 1).Value
x1 = WorksheetFunction.Min(x1, x2)
x2 = WorksheetFunction.Max(x1, x2)
Set rng1 = .Range("a7:aa7")
For Each c1 In rng1
If c1 >= x1 And c1 <= x2 Then
MsgBox c1.Address
End If
Next c1
Next c
End With
End Sub |
Sorry for failing short of expanding the detail.
|
Cs condition zero funciona no win 7 Excel conditional formatting more than 3 Excel function to copy value from one cell to another sheet only if the cell has word mike Excel highlight cell if contains data How can i back up my files if my computer doesn't boot? How to clean virus from computer if you cannot execute any program How to colour a cell by if function in excel How to determine if a website is secure How to fix my cable box if it says alt How to fix your ps3 if your online account never worked How to put multiple condition in excel without using if function How to tell if have java enabled phone If my mac crashed how do i get my purchased songs back Nokia cs10 no windows vista nao funciona Two conditions in an if function Vba date based on condition What do i do if i know who hacked into my network? Which function will allow me to select specific data excel