Hello again,
im working on a database, programed in vba excel. What Im looking for is the following function: I do have a drop down menu, where I can pick out building names. Corresponding to this building names are values about this building (in the same line). Now I would like to be able to select the buildings over the drop down menu (with their name) and when I do that a value from row C is picked and written in a random excel cell. --> Look the matrix below for explanation(the whole this should be dynamic, means that if I put new buildings I can select them as well):
building name / values
A B C D E .....
aa
bb
cc
dd
dd
...
DROP-DOWN
aa
bb
cc
dd
...
Formula --> gives me value from column C from the selected building (f.e. cc)
I am happy for proposals with or without vba.
Thank you!
Matthias
Bookmarks