Related:
- If statement for data in columns
- Fenix internet on bank statement - Guide
- Display two columns in data validation list but return only one - Guide
- An if statement nested within another if statement will produce how many possible results? - Guide
- Excel if statement - Guide
- Tmobile data check - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Mar 26, 2010 at 11:33 PM
Mar 26, 2010 at 11:33 PM
what is meant by "value in column 2 is returned... "
If the value in colum B is found in column A then that value in column B is colored yellow by this macro given below
If the value in colum B is found in column A then that value in column B is colored yellow by this macro given below
Sub test()
Dim r As Range, c As Range, cfind As Range
ActiveSheet.Cells.Interior.ColorIndex = xlNone
Set r = Range(Range("B2"), Range("B2").End(xlDown))
For Each c In r
Set cfind = Columns("A:A").Cells.Find(what:=c.Value, lookat:=xlWhole)
If Not cfind Is Nothing Then c.Interior.ColorIndex = 6
Next c
End Sub
Mar 29, 2010 at 06:11 AM
APP 8081080
APR 8091000
AVO 8044000
CHERRY 8092095
not quite but the code will help me with another issue,, thanks you.
what im after is the value from column 2 if the my selected cell has the same value as column 1.
so for instance if D1 = APR
I want to search column 1 (any where as the row numbers will be different) and
return the value 8091000 next to it from column 2 .
it only works if the D1 is in the same row number as the columns.
i hope this is celarer...