Because the daily list varies...the formula below I'm been using shows the number of times a particular number has appeared. Obviously, since I won't ever have all 80 numbers I'm getting the dreaded "#N/A".
I want to eliminate or hide that...
=INDEX($AH$1:$AH$80,MATCH(BJ1,$AG$1:$AG$80,0))
Any suggestions on what I need to add to my formula to do this?
Last edited by khank; 10-04-2012 at 08:29 AM.
=iferror(INDEX($AH$1:$AH$80,MATCH(BJ1,$AG$1:$AG$80,0)),"")
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Hey thanks for the help...some days you can't see the trees for the forest...again thanks.
You are welcome.Originally Posted by khank
Happens from time to time, to all of us!
how about =iferror(INDEX($AH$1:$AH$80,MATCH(BJ1,$AG$1:$AG$80,0)) ,"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks