How can I return a value of 0 when my array formula brings back a result of "#N/A" ???
This is my formula for this headache of mine.
=INDEX('DATA Needed'!C2:C22,MATCH(Destination!C2:C14,'DATA Needed'!B2:B22,0))+TRANSPOSE('DATA Needed'!C2:C22)
Any help would be greatly appreciated
The #NA is being returned because at least 1 part of your formula is not producing a result (cant find what you are looking for). Try this...
=iferror(INDEX('DATA Needed'!C2:C22,MATCH(Destination!C2:C14,'DATA Needed'!B2:B22,0))+TRANSPOSE('DATA Needed'!C2:C22),"")
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
Thx. Worked like a charm!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks