PDA

View Full Version : Solved: Formula Results are #N/A because od no data



mike31z
04-30-2007, 04:49 PM
I solved my earlier problem of copying data from one sheet to another were the data is not in numerical sequence by using the Vlookup thanks to (mdmackillop). Here is a follow on problem; Because there are formulas on numerous cell with out data the result is "#N/A"
Is there a way to hide the "#N/A" entry?
My solution is to create a macro to color all the cell that equal "#N/A" to white so that they are not seen on the connected tv monitor that allows people to see there scores.

Any other ideas?

PS: I can live with the "#N/A" but if there is away to hide them that the ticket because it will reduce question by the non excel people wiewing the data.
Also the "#N/A" don't need to be printed when reports are created.



Mike in wisconsin

lenze
04-30-2007, 05:55 PM
This is a common question. You can us an IF statement to remove the #N/A

=IF(ISRROR(VLOOKUP(A1,myTable,2,False)),"",VLOOKUP(A1,myTable,2,FALSE))

lenze

mike31z
04-30-2007, 08:17 PM
That is excellent. Thank You Much


Mike In Wisconsin