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 ...
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 ?
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.