Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Select Case to determine correct lookup table

Avatar of KatZoo
KatZooFlag for United States of America asked on
Programming Languages-OtherMicrosoft ExcelVB Script
12 Comments1 Solution343 ViewsLast Modified:
I am trying to write code that will take the value in column H in the sample spreadsheet and use that value to determine the correct column to use in a lookup table (labeld Z in sample).  Once the correct table is located, the value in column A is the range used to determine the value that goes in colum B.  I have used do until, for next, for each next, if---then---elseif statements and the case select.  All codes do the first three values correctly and then assumes all other values are true for the lookup table used for the third sample.  .  I have attached a sample workbook (note:  in my original workbook there are formulas in column A & H that copies the given values from another worksheet to this one).  Also, in column D I have given what the final results in column B should be.
Avatar of Rodney Endriga
Rodney EndrigaFlag of United States of America imageData Analyst

Our community of experts have been thoroughly vetted for their expertise and industry experience.

This problem has been solved!
Unlock 1 Answer and 12 Comments.
See Answers