Adding input into cell

Hello,

I have what would seeming be a simple question but for the life of me I cant fathom it out and Google isn't helping me very much.

What I am trying to do is have a drop down list when selected it does a VLOOKUP and if it matches a value put that value in the cell two right of it. This works perfectly. However what I want is if there is no match then to run some code to ask the user the amount and then place that in the cell.

So this is what is currently in the cell:

=IF(VLOOKUP(B4,Input!$C$1:$D$60,2,FALSE),VLOOKUP(B4,Input!$C$1:$D$60,2,FALSE),AddCost())

AddCost() is the Function I am having issues with so here it is:

Please Login or Register  to view this content.

As yuo can see I am trying to get the input out by using a messagebox for testing but ideally it would need to be in the column two cells to the right so the Vlookup is in Column B and the value should go into the same row on Cell D

Can anyone see where I am going wrong?

Thanks

Hello,

Thank you for your response.

Sorry for being stupid but I have never heard of a worksheet change procedure. Where would I have to put this and where / how do I call it?

Thanks

Thank you I have added it in and taken out my IF statement. It does the lookup but doesn't seem to prompt for the input box unfortunately unless I have done something incorrectly?

Thanks

Hello,

Thank you for your post after some figuring out of what the code was doing and why it wasn't playing I realised that it wasn't erroring it was returning a blank cell because the cell was empty in the previous sheet.

After some googling around I found the isEmpty function. So Combined with that and the code provided I tweaked it so it is:

Please Login or Register  to view this content.

So now it works perfectly. Thank you for all your help.

James