I am currently building a risk report model and have no problem utilizing VLOOKUP with MATCH and MAX to return the greater of two inputs in two categories. However when I apply the code to a logic prgoression so that the max can be returned as a string for another report tab, the code is simply returning the string corresponding to one column vectors input, rather than establishing the max of the two and returning the string for the max. The code is as follows ( I would greatly appreciate some help, Thanks) :

=IF(VLOOKUP(B4,database!$A$3:$AG$2000,MAX((MATCH("Risk Impact, After Control, Financial, 1 Yr",database!$2:$2,0)),MATCH("Risk Impact, After Control, Non-Financial, 1 Yr",database!$2:$2,0)))=5,"VH",IF(VLOOKUP(B4,database!$A$3:$AG$2000,MAX((MATCH("Risk Impact, After Control, Financial, 1 Yr",database!$2:$2,0)),MATCH("Risk Impact, After Control, Non-Financial, 1 Yr",database!$2:$2,0)))=4,"H",IF(VLOOKUP(B4,database!$A$3:$AG$2000,MAX((MATCH("Risk Impact, After Control, Financial, 1 Yr",database!$2:$2,0)),MATCH("Risk Impact, After Control, Non-Financial, 1 Yr",database!$2:$2,0)))=3,"M",IF(VLOOKUP(B4,database!$A$3:$AG$2000,MAX((MATCH("Risk Impact, After Control, Financial, 1 Yr",database!$2:$2,0)),MATCH("Risk Impact, After Control, Non-Financial, 1 Yr",database!$2:$2,0)))=2,"L","VL"))))

This is only reporting from the "Risk Impact, After Control, Non-Financial, 1 Yr" vector rather than establishing the max with the "Risk Impact, After Control, Financial, 1 Yr" vector

Daniel