Trying to incorporate ="NA","", in this formula, having no luck. I want it so when the match-index retrieves a text "NA" it leaves the cell blank. But still wanting to leave the ERROR.TYPE function in there.
=IF(page!$C$10>=$G1158,(INDEX(page!$1:$1048576, MATCH($G1158,page!$A:$A,0), MATCH(X$1155,page!$1:$1,0))), ERROR.TYPE(7))
Please Login or Register to view this content.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Keep retrieving #N/A's for everything now
Sorry, it was a new function for me. The test for the value goes in the function.Please Login or Register to view this content.
daff, thanks for your help but...
Still retrieves #N/A for every cell.
The formula tests for the data to not fill in past a certain date (page!$C$10>=$G1158). So all future dates come in as #N/A which is fine, but when a certain past date matches an NA in my data set - I need it to go blank. I am hoping to make this NA's blank. Because it's graph data and keeps picking them up as zeros.
This would be considerably faster and efficiently if you could create small example on a worksheet.
Just copy and paste.
=IF(INDEX(page!$1:$1048576,MATCH($G1158,page!$A:$A,0),MATCH($X$1155,page!$1:$1,0))="NA" OR(Key!$C$10>=$G1158),"",INDEX(page!$1:$1048576,MATCH($G1158,page!$A:$A,0),MATCH($X$1155,page!$1:$1,0)))
Now I am trying this, still not working
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks