Using Vlookup to directly lookup values instead of looping through combobox

**waimea** · 09-17-2018, 07:22 AM

I have crossposted a smiliar thread at mrexcel!

I have a workbook where I am trying to create a Dashboard.

At the moment I am looping through values of an ActiveX ComboBox and using the linked cell to lookup values. I am also checking if checkboxes are true or false to include/not include variables in my analysis.

Is it possible to access the data directly with Worksheetfunction Vlookup? In some cases I would like to deduct a cell from another cell.

So instead of looping through the ComboBox values (City1 to City25) I would loop through one or two values. Ex. (City1 and City2). Looping through all values takes a couple of minutes and sometimes I would just like to get values for one or two cities at once.

Are there any other ways of doing what I am trying to do? Maybe Select Case for the CheckBoxes??

See attached workbook for more details.

**waimea** · 09-17-2018, 08:13 AM

Please Login or Register  to view this content.

With this code I can directly access the value that I am looking for.

Say I have a list with:

City1
City2
City3

How can I loop through the list and lookup each value?

**waimea** · 09-17-2018, 09:57 AM

Please Login or Register  to view this content.

I don't understand how I can create a list of cities and then use VLookup on that list?

**waimea** · 09-17-2018, 02:39 PM

Please Login or Register  to view this content.

Why is this not working?

**waimea** · 09-18-2018, 02:49 PM

Please Login or Register  to view this content.

How can I use application.worksheetfunction.rank on this array?

Also, what is the best way to handle checkboxes?

**waimea** · 09-19-2018, 03:23 PM

Could anyone help me with how to correctly use Application.WorksheetFunction.Vlookup with an array?

**waimea** · 09-19-2018, 04:17 PM

I got it to work. Now I have a different problem.

Should I use If and ElseIf or Select Case for my 10 array items?

Please Login or Register  to view this content.

How can I create a select case statement for each column in my array?

**waimea** · 09-20-2018, 09:12 AM

Could anyone help me with this?

Using Vlookup to directly lookup values instead of looping through combobox

LinkBack

Thread Tools

Rate This Thread

Display

Using Vlookup to directly lookup values instead of looping through combobox

Re: Using Vlookup to directly lookup values instead of looping through combobox

Re: Using Vlookup to directly lookup values instead of looping through combobox

Re: Using Vlookup to directly lookup values instead of looping through combobox

Re: Using Vlookup to directly lookup values instead of looping through combobox

Re: Using Vlookup to directly lookup values instead of looping through combobox

Re: Using Vlookup to directly lookup values instead of looping through combobox

Re: Using Vlookup to directly lookup values instead of looping through combobox

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Sum values using vlookup with lookup cell containing comma separated values

[SOLVED] populate worksheet cell based on two dimensional lookup values of combobox

[SOLVED] VLOOKUP, 2 lookup values; then sum the lookup returned

[SOLVED] Perform a Vlookup using a Form ComboBox as the Lookup Value

Combobox Populating via a list or directly typing

stop combobox lookup defaulting values

looping over combobox names

Bookmarks

Bookmarks

Posting Permissions