hello.
I am working on learning vlookups..
I have enclosed a snapshot of what i am trying to get rid of..
The vlookups work fine, but when I auto-filled to have the rest fill in (like a list of products and their costs), where there is no value yet, you get that #N/A symbol. And, because of that symbol, I cannot get a running tally for the total cost..that also comes up #N/A.
Is there a way to not have this(#N/A) show, when there is no value yet in that row to fill in the lookups, and also have a total work with that column that now does have that showing??
I hope that makes sense, but I think the snapshot shows it best.
thanks
babs
Picture 6.jpg
Bookmarks