relationship between pop up window and sequential data

[Khanyipass123]

Hi Everyone.

I wonder if someone can help.

I am busy creating automated invoice. i need to know how to create relationship between pop up window / list and sequential data?

for example: if I select a company name on my window, I need physical address, email address, contact number to automatically appear. 

[#2 · Accepted solution]

@Khanyipass123 

You may create table with all customer data (company name, address, etc). Company name column could be used for data validation drop-down list in some cell within invoice. Other fields could be filled by any lookup formulae (e.g. XLOOKUP) from that table.