I have a spreadsheet gathering information on vehicles. One of the pieces of information is a 'Date Off Strength'.
For the vehicles still on strength I have the symbol '#N/A' showing,, this is linked to a sheet using a VLOOKUP formula, is there a way to stop this symbol showing
Thanks
Last edited by VBA Noob; 10-03-2008 at 02:06 PM.
If your formula is
you can use IFERROR if you have Excel 2007:=VLOOKUP(A1,A10:A100,2,FALSE)
=IFERROR(VLOOKUP(A1,A10:A100,2,FALSE),"")
Thanks WMorrison49,,
I did have 2007 on this system but my work is still using 2003 so I switched back
Hope that helps.
Please Login or Register to view this content.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
ChemistB
Your first equation worked perfectly,,, thank you for your help,,,much appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks