I am using an excel sheet to automate the process of calculating fiber dataloss.
The problem I have is the following:
I am using the values in the "Soorten Vezels" part of this sheet to generate a dropdown menu in another part of the worksheet. To keep this excel file really customizable, I want to be able to add a new type of fibre and then just add the max allowed loss next to it.
Somewhere else in this sheet, I will be able to choose the type of fibre in a dropdown menu and then the excel sheet will automatically enter the max loss ( the one next to it in the pre-made list) in another field next to it.
I hope I have made this clear enough
By using this:
with "type kabel" will be the value wich I am looking for in tabel3 and this works. However, if I do the same in another field:
it gives me the error:
What Is wrong?