MATCH using Multiple Criteria and Return the Row Numbers

Hey,

I'm relatively new to Excel and I'm currently trying to use it as a sort of database (as restricted access to other programs). I'm use to computer programming so I'll try explain it in those terms.

I have a worksheet of data, I want to search that worksheet of data using VBA for ALL rows which have XthisX in column B and XthatX in column D and return the ROW numbers. I then want to LOOP through the row numbers and format the data myself programmatically.

Any help on this matter would be very much appreciated.

-Vince

performance_tracker.xlsm

Thanks for the reply Hahobe.

I'm afraid I'm not doing too well comprehending VBA.... :/

Please Login or Register  to view this content.

The above code filters correctly however, the range address shows $A$2. I figured it would just be a case of looping through the rows and pointing to the using I.E Range(LOOPED_NUM,"A").Value and so on. I guess it's not that simple right?

Forgive my inability to comprehend your answer, I try too hard to run before I can walk.