ST Alpha - "STIS: Excel - I have a data on one tab. Dropdown list based on items on that tab on another tab. When I select something in the list, I want to " (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 155

STIS: Excel - I have a data on one tab. Dropdown list based on items on that tab on another tab. When I select something in the list, I want to

Posted by colin (aka colinski) Sep 1 '22, 13:05

populate some other cells on the tab with the list with some data from the original tab.

For example, I have a list of building names. If I select that building name, I also want to copy over to the new tab the cells that have address and phone number.

Something like if value from TAB1 A1 is selected in a dropdown list in TAB2 A1, I also want TAB1A2 to be copied into TAB2A2, TAB1A3 copied into TAB2A3. Then same if I go down a row.. it tracks with the row on the source tab for the dropdown items.

VLOOKUP seems to be the way to do it, but I'm not seeing it...

Responses:

xlookup is sexier, but yes, it should work. if you need help and it's nonconf email what mary at the g and I am happy to. -- nm - amanda Sep 1, 13:07 2
- thank you! i'll drop you an email tomorrow, going to wrap up for today, i can't do any more data :) -- nm - colin Sep 1, 13:24
- xlookup is so sexy they should call it xxxlookup. -- nm - Max Sep 1, 13:08

Post a message top

STIS: Excel - I have a data on one tab. Dropdown list based on items on that tab on another tab. When I select something in the list, I want to

Replies are disabled on threads older than 7 days.