Forum Discussion
Lookup/Autofill function
I opened a new excel sheet. In one tab I have a list of company names. In the other tab I would like to go to any row in a column and start typing one of those companies names from the other tab and ...
You can actually achieve this using a drop-down list.
Select the range C3:C50 then select ‘Validation’ from the Data menu > Select list in the Allow option drop-down > click in Source Control and select the range, on the other sheet, which includes your list of vendors (you can also choose here whether you want to show the drop-down arrow in the cells so you can choose the vendor from the list - check the In-Cell Drop-down box).
Note: If you have two entries which start withe same letters, you will not be given a suggestion for the entry until you reach the first unique letter..... e.g. in a list of countries containing United States of America, United Arab Emirates and United Kingdom; when typing in United Excel can’t differentiate between the three, only when you type the first letter of the second word, I.e. the S of States, would Excel offer auto-fill for USA.
Select the range C3:C50 then select ‘Validation’ from the Data menu > Select list in the Allow option drop-down > click in Source Control and select the range, on the other sheet, which includes your list of vendors (you can also choose here whether you want to show the drop-down arrow in the cells so you can choose the vendor from the list - check the In-Cell Drop-down box).
Note: If you have two entries which start withe same letters, you will not be given a suggestion for the entry until you reach the first unique letter..... e.g. in a list of countries containing United States of America, United Arab Emirates and United Kingdom; when typing in United Excel can’t differentiate between the three, only when you type the first letter of the second word, I.e. the S of States, would Excel offer auto-fill for USA.