-
Solved: Formula Results are #N/A because od no data
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
-
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
-
That is excellent. Thank You Much
Mike In Wisconsin
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules