hello,
i have created a dropdown list which i would like to link to another cell.
the data from this cell will then allow a vlookup to operate in a 3rd cell.
essentially:
- M9 = dropdown list (1, 2, 3)
- F6:F8 = cells that dropdown list refers to (a, b, c)
- M13 = vlookup on F6:F8
i am trying to get:
- dropdown list "1", refers to "a", vlookup outputs "message1"
- dropdown list "2", refers to "b", vlookup outputs "message2"
- dropdown list "3", refers to "c", vlookup outputs "message3"
any help would be greatly appreciated.
i have created a dropdown list which i would like to link to another cell.
the data from this cell will then allow a vlookup to operate in a 3rd cell.
essentially:
- M9 = dropdown list (1, 2, 3)
- F6:F8 = cells that dropdown list refers to (a, b, c)
- M13 = vlookup on F6:F8
i am trying to get:
- dropdown list "1", refers to "a", vlookup outputs "message1"
- dropdown list "2", refers to "b", vlookup outputs "message2"
- dropdown list "3", refers to "c", vlookup outputs "message3"
any help would be greatly appreciated.