PDA

View Full Version : VBA Code Help Needed. Lookup Value Ranges



seulberg1
06-25-2014, 05:34 PM
Hi

I am fairly new to VBA and want to code a macro that allows me to look up the exact cells of the Top5 values in a specific range, restricted by criteria. The Sheet looks like this:



A
B







6
North







4
East







99
South







6
West







4
North







2
North








I want to lookup the 5 highest values in a range like in column A, given that they meet the criteria of having e.g. "North" in B. But i am not only interested in the exact numeric values of the Top5, but also in which row they are in.
I would need an output of that into a seperate sheet.

Can anybody help me? I hope I explained the problem properly.

Thank you
seulberg1