Create Vlookup using prompts/input fields

[phil-007]

Hi All,

I'm trying to make Vlookup's easier for my colleagues to do themselfves, does anybody know of a way of using [open brackets], or using a userform or VB like in Access to give the user a friendylier way of selecting the vlookup options?

Hope that makes sense

Thanks

PHil​

 

[Mile-O]

I'm trying to make Vlookup's easier for my colleagues to do themselfves, does anybody know of a way of using [open brackets], or using a userform or VB like in Access to give the user a friendylier way of selecting the vlookup options?

While you can use VBA and Userforms in Excel, it sounds like completely overcomplicating something.

First, why not just explain the VLOOKUP to colleagues (it's not as if in-built help doesn't detail its use) rather than doing extra work.

By [open brackets] I'm guessing you mean some sort of Parameter. But you could do some work with setting up a tab for lookups, etc.

But, without ultimately knowing what's going on - no example, for example - its hard to say.

 

[scott-atkinson]

I agree with Mile-o, the Vlookup function is probably one of the more simplistic functions in Excel to use, unless your audience has no knowledge and use of any kind of formula in Excel then you are over complicating something that could be tackled with some short tuition.

What I have done with Vlookups, just to assist myself especially when selecting data to display in a chart, is to have a Validated Cell with a drop down list of possible selections, both for the Row and Column requirements, and then have a formula that references the values selected in each cell... This may help to simplify the Vlookup function if you really need to.