Question

[ntrddragn]

Hi Im new here but i have a question regarding excel but i dont know what the best function to use so i cant search it. =/

i have a sheet where users can pick from a list (list is from data validation). each item they pick has a value. what i want is for them to stop being able to pick from list once the max value (40) is reach. once that is reach and if they wanted to add more they will need to change one or of the items they have already picked. this will decrease/increase the value until again it reaches 40.

I was able to use data validation to stop at the max but the issue is once they reach the max they cant change the items that was picked already.

thanks
richard

 

[Tigs81]

I assume that the user is able to clear a cell, which will then reduce the 40 to something lower, and then they will get the list back?

Thanks
Tigs

 

[ntrddragn]

its to much to let them do that. =D its a vlookup and they dont want to have to deal with erasing and copying vlookup formulas. and if you erase the cell that contain the data validation reference it makes the vlookup reference n/a and the DV is still lock.

 

[Tigs81]

Can you use an if statement to prevent the vlookup from working if it errors using the ISERROR formula?

 

[ntrddragn]

Can you use an if statement to prevent the vlookup from working if it errors using the ISERROR formula?

LOL..OMG. im so retarded. thanks. i guess i was making it more complicated then it needs to be.

 

[Tigs81]

no worries
i am glad its sorted.

Thanks
Tigs