Help with a Do Loop that runs off a VLookup and a Pick list

**delaneybob** · 06-13-2012, 06:13 PM

Hi,
I have a complicated equation that I can not isolate the parameter by itself to solve for it. So I have to compare the result to a minimum result and increment the parameter via a VLookup (can be repalced by a list if needed) up to the minimum result. when that value goes over the minimum, i need to return the parameter

I hope I explained it well enough. Unfortunately, the person wants the VBA code to tell him the parameter rather than pick it from a pick list until the formula says the minimum has been reached

Something like this (B98 is comparing the result to the minimum, once it reaches the minimum, it will say "piping OK"

Please Login or Register  to view this content.

**rylo** · 06-13-2012, 08:14 PM

Hi

Got some sort of example file so we can see what your process is and what you are trying to achieve.

rylo

**delaneybob** · 06-13-2012, 08:57 PM

It is attached- I need to go thru the pull down list values which correlate to the table to pull the actual value to use in the calculation

**rylo** · 06-13-2012, 09:28 PM

Hi

The example file list and the list in the drop down don't seem to align, so I couldn't test this properly. If you can modify your example file so that it will run from the listing in I8:J19 then try something like:

Please Login or Register  to view this content.

HTH

rylo

**delaneybob** · 06-13-2012, 09:48 PM

Hi rylo,
trying to get the code to work no dice The drop down list in B3 is in effect I8:I19. It's just i need to use the adjacent value in column J for the calculation. So i want to walk the values in I8:I19 until I get "Pipe Length is OK"- does that help?

**rylo** · 06-13-2012, 11:28 PM

838102.xlsmHi

I've modified your file and put revised details in column C. The list is now linked to the data in J8:J19. I've modified the vlookup formula so that it will still work.

There is a macro called DeterminPipeSize which will get the first valid result and put it into C3.

rylo