Hello
If as a result of a vlookup the contents of cell G75 is #N/A - how can I make it £0.00 instead?
The column contains various amounts, but there will be times when the macro is run when some cells will have #N/A and others will have a £ value. So to make it easy on the eye of the reader, I'd like to get rid of the #N/A.
I've had a look and it is possible to use an IF statement with a VLOOKUP however, my cell is an error opposed to valid data.
Hope this makes sense!
thanks
Denise
=iferror(yourlookupformula,0)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Excellent, thank you. I was getting myself all confused and it was something as simple as that!
No problem, glad you got sorted!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks