How to give values from excel with two entries?

1

Hi everyone,
I have an excel file. In columns, I have the columns(revit category) location marks. In rows the base level.

I’m trying to get the information from the excel file and set this value into a parameter.

If you see my excel file. A structural column whose location mark is A-1 (grid lines) and whose base level is L000 would get the value “M”.
A structural column in grid B-2 level L011 would get the value “X”.

I’m trying to use a dictionary but honestly I don’t know where to start.

Thank you in advance.

COLUMN_VALUES.xlsx (9.2 KB)

structural%20columns%20values
structural columns values.png1222×592 32.1 KB
structural%20columns

2

here is how to get your dictionaries
and how to get the parameters

Capture
Capture.png1339×823 95.2 KB

3

Thank you very much that works perfectly.