Hi all, here is a copy of an example spreadsheet layout.
#...Name..Status Code
043 Brute Active Blue
044 Brute Active Green
..... Kevan Closed Blue
045 Brute Opened Blue
046 Jacky Active Blue
047 ...... Disabled
Basicly what I want to do is iterate down the list row by row.
I want to see if column two equals "Brute" and column three equals "Active".
If it both match than output the contents of column 1 into lets say column 5 row 2.
Any help would be greatly appreciated.
Last edited by VBA Noob; 05-07-2008 at 02:47 PM.
You can use Index/Match
e.g.adjust ranges to suit and then confirmed with CTRL+SHIFT+ENTER not just ENTER.. you will see { } brackets appear around the formula
Please Login or Register to view this content.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
That works, but it only gets back one instanse of the match. I need it to return all the values that match that criteria. So if two match there would be a result of something like '043 044'. Any ideas?
Try
Confirmed with CTRL+SHIFT+ENTER and copied down.Please Login or Register to view this content.
Assuming that # is in Range("A1")
Then you can make a macro that does the check for you.
Sub match_Brute_active()
Dim i as int
i = 1
do while Activesheet.Cells(i,1).value <>""
if Activesheet.Cells(i, 2).value = "Brute" And Activesheet.Cells(i,3).value = "Active" then ' it's case sensitive
Activesheet.Cells(i,5).value = 1
endif
i = i +1
loop
end sub
I tweaked the code and it works perfectly. Much appreciated. THANKS AGAIN!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks