Hi, i have array formula =IFERROR(INDEX(B3:D8,MATCH(F1,A3:A8,0),MATCH(F2&F3,B1:D1&B2:D2,0)),"error")
but problem ise when i sama date on A column, i cannat get error message.
Hi, i have array formula =IFERROR(INDEX(B3:D8,MATCH(F1,A3:A8,0),MATCH(F2&F3,B1:D1&B2:D2,0)),"error")
but problem ise when i sama date on A column, i cannat get error message.
It's unclear what problem you're having. Can you provide additional info and/or update your sample file to show BEFORE and AFTER of the problem you're having?
hi, formula is working.
but when i type (mistakenly) same date on A column, formula is return first date result. For example (you can see on file), A3 and A4 same date (17/04/2014) when you change F1 to 17/04/2014 result is 2. but result must be error. Because there is 2 same date on A column.
=IF(COUNTIF(A3:A8,F1)>1,"hata",IFERROR(INDEX(B3:D8,MATCH(F1,A3:A8,0),MATCH(F2&F3,B1:D1&B2:D2,0)),"hata"))
Try this formula
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
many thx. its worked.
If your question is resolved, mark it SOLVED using the thread tools
and Click on the star if you think some-1 helped you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks