Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and Replace Lookup errors
I'm trying to replace two error messages (#N/A and #VALUE!) found throughout
my spreadsheet. The error messages are a result of lookups that cannot find values on my look up tables. I would like those cells to show up as blank for reporting purposes. I tried to do a find and replace. I did a find ...look in...values...find all. The cells were all found. I leave the replace box blank and click on replace all and get an error message. After trying several times, I find that the "look in" box on the replace page no longer has values highlighted and fact values doesn't even show up. How can I replace all the look up error messages with blank cells? -- Julie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
Find and replace with a lookup | Excel Worksheet Functions | |||
To find errors | New Users to Excel | |||
find replace cursor default to find box | Excel Discussion (Misc queries) |