Writing =IF(ISBLANK($H4), "", VLOOKUP($H4,DCID[#All], 3, FALSE)) to a cell and work

**smit.etha** · 09-20-2015, 03:57 PM

I have some cells that pull info using the VLOOKUP if a value is in a database. If the value isn't in the database, the user can manually type it in but it overwrites the equation. I want to be able to "reset" the table to the original conditions. Ie, if a user overwrites my "=IF(ISBLANK($H4), "", VLOOKUP($H4,DCID[#All], 3, FALSE))" but later wants that equation back, I want to be able to write =IF(ISBLANK($H4), "", VLOOKUP($H4,DCID[#All], 3, FALSE)) to the cell and have it work.

Thoughts?

**davesexcel** · 09-20-2015, 04:36 PM

One example, if your formulas are in column "A" and somebody replaced a formula with a value then this would work using specialcells.

Please Login or Register  to view this content.

I suppose a more elegant way would be to just replace the cells with the formula.

Please Login or Register  to view this content.

Writing =IF(ISBLANK($H4), "", VLOOKUP($H4,DCID[#All], 3, FALSE)) to a cell and work

LinkBack

Thread Tools

Rate This Thread

Display

Writing =IF(ISBLANK($H4), "", VLOOKUP($H4,DCID[#All], 3, FALSE)) to a cell and work

Re: Writing =IF(ISBLANK($H4), "", VLOOKUP($H4,DCID[#All], 3, FALSE)) to a cell and work

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] IF formula not working =IF(NOT(ISBLANK(M3)),"",IF(ISBLANK(L3),"",TODAY()-L3))

[SOLVED] Conditional Formatting a cell from a "true/false" VLOOKUP

[SOLVED] Test for blank cell should be "True" but "False" action is taken.

VLookup to return "true" or "false"

Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" not working

Formula returning result of "True" or "False" instead of "1" or "0"

Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next

[SOLVED] IF(VLOOKUP("MYDATA", MYNAME, 4) = 0, "TRUE", "FALSE")

Bookmarks

Bookmarks

Posting Permissions