Multiple warning messages dependent on Cell value

[mdimiller]

Hello, im looking to create a macro that once an entry is put into a cell in column B, it looks up that entry to a list on a new sheet and then dependant on the lookup value i need 1 of 2 warning messages. I need a warning message if the lookup value is "No" and a warning message if the lookup value doesn't bring back a result i.e #N/A. The other potential value is aYes but need no action for that. The warning message box for the 'No' response, will be a simply yes no answer box, with the #n/a warning message box being a simply ok warning message which then goes back on the cell on column B that was originally selected.

So far i have managed to write the tiny bit of code to enter the v lookup into column c - but am having issues with the multiple warning box. the issues i have had so far have maainly been around multiple warning messages. One message i can do fine (using simliar taks as when adding the vlookup) but then i it errors everytime the #N/A is returned. SO i just need help on having multiple warnig messages if the value in column3 is Yes or N/A. The code i have for the look up is below so any extension to that wold be great

Thanks in advance for your help

Please Login or Register  to view this content.

[protonLeah]

You did not post a sample file to test with so, (??):

Please Login or Register  to view this content.

[mdimiller]

Hi Protonleah, thanks for your response, i have now added an attachment with your below code inserted (ammended the ofsett value slightly). The code seems to error at the "Case IsError(LookupReturn" function. I have tried ammending with an IF function and added in = or "", but can't seem to get it to work?

Thanks in advance

[protonLeah]

Tested ok:

Please Login or Register  to view this content.

[mdimiller]

Hi Protonleah - thanks very much for your assistance, that works great.