I am suspecting this might require a VBA solution and am far from skilled in that to create it. Hopefully, a clear explanation follows:
Ideally, I'd like to "prompt" my user for three different criteria, each of which would be a column (e.g., Name, State, Title).
Then, where there is a unique match in the spreadsheet, subtract yet another value provided by the user from yet a fourtth cell (e.g., inventory).
So, for "Weaver", "Florida", "Manager" and Inventory = 10, find the unique row matching the first three criteria and subtract 10 from a specific column in that row.