How to find max value in a range then give value in cell 2 rows above that max

[danchristie]

I'm looking for a fomula that will find the largest number when comparing cells B5 and B8 below then give me the value of either B3 or B6 dependent on the maximum value that was found in step one.

So in this example B5 = 130 and B8 = 100, so 130 is max, so I want B3 to be my result (V130B25)

Any hepl will be greatly appreciated

AB1Rectifier and Equipped Capacity (# of installed rectifiers) 2Rectifier ManufacturerLorain3Rectifier Model #V130B254Qty25AMPS Each1306Rectifier Model # (if multiple models)V100B257Qty18AMPS Each100

 

[danchristie]

Here's the example.....the table didn't paste


A B
1 Rectifier Manufacturer Lorain
2 Rectifier Model # V130B25
3 Qty 2
4 AMPS Each 130
5 Rectifier Model # V100B25
6 Qty 1
7 AMPS Each 100