Forum Discussion
help with made a data table
I want to create a data table with the following rows:
Product Name:
price:
serial number:
In another file I want to pull all the data from the above table using a keyword.
for example:
I will write the name of the product and the price and the serial number will be automatically completed.
I would appreciate your assistance.
benihai I can only guess as to what you actually need, but perhaps the attached example can help you get started. It works if you are using a modern Excel version, by the way.
- thanks
but how i made it ?benihai That's a broad question. All you need to learn is documented in Microsoft's support pages on-line.
The example uses a structured Excel table. More about such tables in the link below:
Then cell H3 contains a drop down list (i.e. Data Validation). More about that in the following link.
H5 and H6 both contain contain an XLOOKUP function. More about that function here:
XLOOKUP function - Microsoft Support
If you are not on a modern Excel version, look into the VLOOKUP function.
