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 a different worksheet and it auto complete the items # and material. Thanks in advance for any ideas on how to make that work. Here are images to help out.
Image 1: The worksheet I want to be able to enter item's name and autocomplete
Image 2: The info I want to pull the data from to complete Worksheet 1
4 Replies
You can do it using Vlookup
from the name it will search vertically for the value you inputted "the name" and it will return another value "the description" or "the material"
please see an example of the implementation
Ramiz_Assaf Thank you for the example!
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!
