VBA to eliminate nested IF function & provide result based on range

Hi,

Hope all had a nice week end.

I have set of data for which I have to assign a value in Cold H based on a values from A to G. Using nested if function I am able get the result that I want .
But, the conditions for If's and rows are going to get extended like 200k lines of data & conditions are going beyond 40 combinations.

I thought of checking if there is a solution vba to do this function using conditions from another Range. I can create one mapping reference table & then VBA should pick up conditioons accordingly. In future, if conditions changes I can update on the "conditions" range and macro can pick them accordingly.
(refer the image below, and also I attached the file for reference. )

Mapping image.PNG

Thanks in advance
Regards
Arvind

I don't think that is necessary to write a VBA code for that. You can use tha formula:

Formula:

Please Login or Register  to view this content.

and press CTRL+SHIFT+Enter (is an array formula)
The index-match combination is faster than IF or Vlookup