Forum Discussion
How to use a keyword to input data for the whole row?
, I am very new to the program. So in advance, excuse my lack of terminology. I was looking to have a worksheet with info on items name, # and material. I want to be able to type in the items name on...
DruJackson Since you are new to Excel, I suggest you read into the basics of the VLOOKUP and/or XLOOKUP function. The latter may not be available on your Excel version though.
https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1
Furthermore, you may also want to learn about Data Validation. More about that, here:
Based on your example, I have created a very small modell (see attached workbook). Perhaps useful to see these features in action.
Riny_van_EekelenThank you for the example!
