98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel INDEX & MATCH Functions
Excel INDEX & MATCH Functions
Resolved · High Priority · Version 2003
Fri 10 Oct 2008, 14:51Delegate Dee said...
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
Thu 23 Oct 2008, 14:40Trainer Laura said...
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
Thu 30 Oct 2008, 11:16Trainer Rich said...
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
Mon 10 Nov 2008, 08:35Trainer Laura said...
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
Tue 18 Nov 2008, 10:49Trainer Rich said...
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
Thu 18 Dec 2008, 09:17Trainer Rich said...
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
Thu 26 Mar 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Quickly hide and unhide rows and columnsUse the keyboard shortcut Ctrl+9 to hide selected rows and Ctrl+0 to hide selected columns. The good thing about this shortcut is that you do not need to select entire rows or columns. For example, select B3:D3 then press Ctrl+0 to hide columns B to D. |
