Dee has attended:
Access Intermediate course
Excel Advanced course
Visio Advanced course
Excel INDEX & MATCH Functions
I am using the following formula {=INDEX(BankHols,MATCH(Month1&Month2,StartDate&EndDate,0))} to lookup and display the value in column 3 of a table (sample below). The formula works correctly except when it reads a 0 value. If a 0 (zero) value is returned the #NA error is displayed.
How can I get Excel to read the table and correctly display the zero value?
Start Date End date No. of BHs
01-Apr-08 30-Apr-08 0
01-Jun-08 30-Jun-08 0
01-Jun-08 31-Aug-08 1
01-Jun-08 30-Sep-08 1
01-Apr-08 31-May-08 2
01-Apr-08 30-Jun-08 2
01-Apr-08 31-Aug-08 3
01-Apr-08 30-Sep-08 3
01-Jun-08 28-Feb-09 4
01-Apr-08 31-Dec-08 5
01-May-08 31-Mar-09 6
Regards,
Dee
RE: Excel INDEX & MATCH Functions
Hi Dee
Thank you for the question.
Could you attach an example so I can fully understand the names you've used in your array formula?
Thanks
Laura GB
RE: Excel INDEX & MATCH Functions
Hi Laura,
Delegates can not currently upload files to the forum due to security reasons.
You can request they send files to forum@stl-training.co.uk and they can be forwarded on to you, or can use another e-mail address of your choosing. If this is the case, it's best to mask the e-mail so spam-bots can not grab it.
Regards, Rich
RE: Excel INDEX & MATCH Functions
Thank you Rich for the advice.
Dee, if you send the file to forum@stl-training.co.uk for my attention that would be great.
Regards
Laura GB
RE: Excel INDEX & MATCH Functions
Laura,
I have forwarded you the copy of Dee's file via e-mail.
Will keep this forum question as 'unresolved' for now.
Regards, Rich
RE: Excel INDEX & MATCH Functions
Hi,
We are clearing some of the outstanding questions in the forum. As this post has been inactive for quite some time, the system will automatically set the post to 'resolved' in the next 5 days unless a follow-up post is made within that time.
You can always mark the question as 'unresolved' at any point if you require further assistance with this matter.
Regards,
Best STL Forum Team
