VLOOKUP -how do I type in the first letter/s of a word and have all matching words come up?

L3arn3r

New Member
Joined
Oct 28, 2018
Messages
2
I need help with vlookup, I want to be able to type the first letters of a word in and have all matching words come up in the dropdown list, any help would be appreciated thanks.
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
Hello,

Your question raises several points :

1. You do NOT need help with Vlookup

2. What you are looking for is a feature called Autocomplete

3. The first step would be a Formula to generate your matches

4. A second step would be to populate your validation list

5. Are you planning to work with a UserForm or directly into a worksheet ...?
 
Upvote 0
Welcome to the MrExcel board!

All the steps to achieve what you have described are given here.
 
Upvote 0
I need help with vlookup, I want to be able to type the first letters of a word in and have all matching words come up in the dropdown list, any help would be appreciated thanks.

James 006 - unfortunately you are talking language i don't understand!! , I am new to excel .
I have a checklist on sheet 1 and a list of items on sheet 2.
each job has a list of items to be allocated to it so when I type the first few letters in the cell I want the dropdown list to show all the items that match the letters typed in , then I want to be able to select the suitable item , click on it so it appears in the cell, and so on until all the items required for the job are in the checklist on sheet 1.
 
Upvote 0
.. so did you look at the link I provided and work through that?
 
Upvote 0

Forum statistics

Threads
1,223,893
Messages
6,175,249
Members
452,623
Latest member
Techenthusiast

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top