multiple lookup

[sfletcher]

Hi:

I am using the following formula to perform a lookup based on dat
entered into two columns (D&E) and input the appropriate matching entr
into column J:

=IF($D6="Very High",INDEX(VH_Risk_Level
MATCH($D6&$E6,VH_Impact&VH_Likeliness,0)),IF($D6="High",INDEX(H_Risk_Level
MATCH($D6&$E6,H_Impact&H_Likeliness,0)),IF($D6="Medium",INDEX(M_Risk_Level
MATCH($D6&$E6,M_Impact&M_Likeliness,0)),IF($D6="Low",INDEX(L_Risk_Level
MATCH($D6&$E6,L_Impact&L_Likeliness,0)),""))))

Column D allows all of the options identified in the formula (Ver
High, High, Medium, etc.).

The problem is that if I select "Medium" in D6, I get a #N/A error.

I've checked all of the ranges for the medium selection (M_Risk_Level
M_Impact, M_LIkeliness)- they are correctly named and sorted, exactl
the same as the other ranges, and the formula works for all of th
other selection combinations.

Also, when I try to audit the formula I get a data validation error an
Excel does a recovery, removing all of the data validations in th
workbook.

Any help in resolving this would be very appreciated.

Thanks very much