Finding specific value

A

alabil

Joined
Feb 24, 2012
Messages
2
Reaction score
0
Hi,

I am having trouble with my formula that give me #VALUE
=INDEX(Budgets!B:Q,BA2,MATCH(IF(MONTH(TODAY()) < 7,YEAR(TODAY()),YEAR(TODAY())+1),Budgets!E10:Q10)+3,Budgets!E:Q)

What I am trying to do is to find a value on another sheets based on an ID, which will give me the row (Budgets!B:Q,BA2) and another criteria based on a fiscal year (IF(MONTH(TODAY()) < 7,YEAR(TODAY()),YEAR(TODAY())+1))

the match formula give me the proper column number if run by itself if as is but if I replace
Budgets!E10:Q10 by Budgets!E:Q I get #N/A so I have to stay with what works unless there is a better solution for the match()

Something is missing and I do not know why, I have been away from Excel way to long...

Thanks
Al
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use TODAY() function as the criteria in a SUMIF formula 1
Word macro that can call cells out of Excel for a find and replace 0
Search closest day in the past from today 2
Autonumber field in Excel that behaves the same as Access 0
Countifs with error #Value! 1
Show value from one cell in another cell if today falls between a date range 5
Combo box and auto fill question 1
tickler for quarterly reports 3

Top