Vlookup and iserror not working properly

[jchapm123]

here is the basic code

Please Login or Register  to view this content.

>>for some reason it will not catch any errors, it will just pull the next row of numeric values.

[rylo]

Hi

Can you please review the forum rules regarding code tags. I've put them in for you this time.

How about adding an example file. I'm not sure what you are pulling from column B. Is it a boolean or a number?

rylo

[jchapm123]

here is the file that I am using. The workbook is protected but there is no problem accessing the macros

[rylo]

Hi

So where do you fill the variable found? As in the test

Please Login or Register  to view this content.

you are testing found against the result of the vlookup???


Or are you trying to see if solv exists in column A?

Maybe explain what you are trying to achieve.

rylo

[jchapm123]

I am trying to find solv in column A or B but I am comparing those results with found. If solv is found then it should proceed, but if solv is not found, "found" should result in an error which should display a message box saying that the results can not be found and then restart the asking process.

[rylo]

Hi

If you are trying to find solv in columns A or B, then vlookup won't really help you much.

Do something like

Please Login or Register  to view this content.

Then you can test found

Please Login or Register  to view this content.

rylo

[jchapm123]

Rylo this works like a charm! I really appreciate all of your help! Thank you