I currently have a Excel sheet that has 2 tabs: 1 tab is called Contacts, the other one is called websites, on Contacts I have a dropdown menu with list of emails that i want to display next to the website they are associated to.
I have currently tried =VLOOKUP(H2, Contacts!B2,2,0)
this did give me the name of the dropdown menu but not the values that come with the dropdown menu.
When this is possible it would be nice that when I were to add something to the dropdown it would update itself too in the websites tab.
I am currently using Excel Online and would like to stick to that if that is possible.
Kind regards,
Mark.