IF, VLOOKUP and CONCATENATE - Issues with formulas working together

[sooxan]

=IF(ISBLANK(G10)," ",(VLOOKUP(CONCATENATE(F10&G10),(Lists!$A$14:$A$22),4,FALSE))) - located in H10


The formula above is what I am using to auto-populate responses for a risk register.

F10 - has 6 options
G10 - has 6 options

These two cells are populated from lists in A 14-20 and A 22 - 28 (including title). The drop-downs to choose the options are functioning as they should.

H10 should auto-complete based on the choices made in F10 and G10.

(EG when a person makes the choice 5 severe in F10 and D unlikely in G10, H10 should auto-fill to High and I11 to 10).


I have been at this for hours now and each chunk of the formula seems ok on its own but altogether the formula does not work.

The formula has colours highlighting errors but I am unsure how to fix them.


Any help is appreciated.

[FDibbins]

Why are you trying to combine (concat) Consequence and Likelihood when all your range shows is consequence?