Im having a little trouble with a part of my workbooks and im hoping someone has the experience to point me in the right direction. im using a formula:

=IF(ISNUMBER(MATCH(A6,'[Members.xlsm]Member Entry'!A10:A700,0)),"1","")

right now if the statement is true then it simply enters a 1 into the cell, What i would like it to do is if it returns true, i would like it to look in another cell in the same row where it found the match, find the value in that cell, and subtract 1 from that value, then display the updated value. Can anyone tell me if this is possible? im open for suggestions also, if you can think of a better cleaner way to do this, im open.

Im also having an issue with: CreateObject("WScript.Shell").Popup "Thank You and Enjoy Your Class.", 2, "Thank You!" it doesnt dissappear after the 2 sec like it should, any ideas??