Excel - Dynamic Table (I think?)

Question

Hi All! I need your help.&nbsp;I have a table of data of which I need to keep the format of for display and presentation purposes, but I want to have it so that when choosing a name from a drop down list, the data within those fields in the table update with data corresponding to that name.&nbsp;How do I do this?!&nbsp;(oh and will it work in Google sheets after as it’s being shared by the business?)&nbsp;

hansvogelaar · Answer

JessT7&nbsp;
Check out the VLOOKUP and XLOOKUP functions. Both work in Google Sheets too.

jesst7 · Answer

Hi Hans, it’s more complex than the VLOOKUP. I need it to be dynamic on choosing from a drop down.

hansvogelaar · Answer

JessT7&nbsp;
Can you explain in more detail what you want to do?

Forum Discussion

Excel - Dynamic Table (I think?)

Share

Resources