If cell contains a specific string then allow cells next to it be manipulated

**koonz99** · 06-24-2013, 04:07 PM

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

**dilipandey** · 06-30-2013, 02:59 PM

Hi Koonz99,

A cell can either have a formula or a user value. If a user enters value, then formula would be overwritten.
Alternatively, you can assign a logic where user can enter in some other cell instead of directly entering over formula cell... for example if d23 contains formula, then user can enter in any other cell .. lets say m1 and you can update formula in d23 as = if(m1="",formula,m1)

Regards,
DILIPandey
<click on below * if this helps>

If cell contains a specific string then allow cells next to it be manipulated

LinkBack

Thread Tools

Rate This Thread

Display

If cell contains a specific string then allow cells next to it be manipulated

Re: If cell contains a specific string then allow cells next to it be manipulated

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions