Hi! I need help to look up a value from a drop-down list in a set of range. I have been using this code:
See the attached excel file for more info: Book2.xlsx
Please Login or Register to view this content.
In cell C175 I have written this code where I want the LOOKUP value to appear. When you choose a value of for example HEA 260 (13%) in the drop-down list (Cell B1) it shows "N/A" in cell C175. And when you choose VKR400x400x16.0 (4%) it doesnt give the correct value in cell C175. Anyone with an idea on how to solve this?