So I use V Look up and sometimes the cell populates with #n/a The problem I have is when I try and use conditional formatting with colors I can't get it to work. So I'm wondering 2 things.
1, is there an easy way to change all #n/a cells with either a 0 or another word/text.
2, is there a way to set up conditional formatting to highlight any cell with #n/a.
Thanks
1. Use IFERROR(your formula,0)
2. see 1
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Confused here.Originally Posted by TMS
I have a V Look up formula in the cell.
=VLOOKUP(A2,'1530'!A:E,5,FALSE)
Formula like that is either giving me a # or a #n/A. How can i incorporate IFERROR in there.
Just as Trevor suggested, wrap your formula in IFERROR()...
=IFERROR(VLOOKUP(A2,'1530'!A:E,5,FALSE),0)
In CF, you can use "Format Cells That Contain" and then select Errors from the drop-down
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Formula:
Please Login or Register to view this content.
Thank you both! Worked great!
You're welcome. Thanks for the rep.
Happy to help, thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks