|I have 2 worksheet in an Excel Workbook.|
The first worksheet has 2 columns, the first indicating room type and the second indicating a numerical value associated with that room type.
For example in Worksheet 1:
Cell A1: Office; Cell B1: 9
Cell A2: Lab; Cell B2: 13
Cell A3: Store; Cell B3: 5
Cell A4: Auditorium; Cell B4: 12
In the Worksheet 2, I have created a drop down list based on Worksheet 1 Cells A1:A4.
What I want to occur in Worksheet 2, is when an item is selected from the drop down list it provides in the adjacent cell the corresponding numerical value, for example if I select Store from drop down list in the adjacent cell I want it to show the 5 (the corresponding value from Cell B3), similarly if I select Lab it will show 13 (the corresponding value from Cell B2), etc, etc
I have been searching and trying various things like offset, if, etc but can't make it work.
Assistance is greatly appreciated