Home

Auotmatic population of a pick list by a keyword

doug_61
New Contributor

Hi All,

I'm creating a costing sheet for equipment and I need to choose similar items from a list. To save sorting through a large pick list I need to be able to type a keyword which will populate a smaller  balloon/picklist from which I can choose the item and return a value from another sheet.

 

Can anyone help with the steps/formula for this?

2 Replies
Please attach your sample file.

@Twifoo 

My apoligies I have been unavailable for a couple of weeks.. In Reply..

 

What we are trying to do is type a keyword into a cell (see A31 below) which will then return a list of items with the same keyword from another sheet that we can select an item from.

 

 

type format.png

 

The list we would get back would look similar to this

 

List of stainless items.JPG

 

Once the item is chosen a value would then populate the corresponding cell in the row, in this case cell D31.

 

The macros seen in the first item are being removed to allow for more space on the A4 page when a hard copy is printed.

Is it poosible to embed a macro into a picklist or vlookup?

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies