Hi guys, I was wondering if anyone could help me. I have a chart where as I add tools to inventory, it auto fills cells E23, F23, G23 by vlookup based on D23 with the following formula, =IFERROR(VLOOKUP(D23,Inventory!$G$14:$P$56,5,FALSE),"")

Is there a way to keep the vlookup formula in that cell but allow cell to be manipulated if a certain string goes in D23. For this case, I'd like it that if the string "Rig" shows up in D23, then E23, F23, G23 can all be manipulated by the user but if string is not found then formula goes back to that cell. Any help would be greatly appreciated. Thanks