Can anyone point me in the right direction on why I'm receiving errors with this formula?
=INDEX('FINANCIALS-PREV'!$B$5:$AB$3000,MATCH($B9&D$8,'FINANCIALS-PREV'!$B$5:$B$3000&'FINANCIALS-PREV'!$B$5:$AB$5,0))
On the table i'm pulling from, row 5 has dates and column B is the name of the job. Can you not do it this way with index/match?
Dont you have to enter as a array formula?
Ctrl+shift+Enter
{=INDEX(range1,MATCH(1,(A1=range2)*(B1=range3)*(C1=range4),0))}
If you find the suggestion or solution helpful, please consider adding reputation to the post.
Tried your formula, still did not work, any idea?
{=INDEX('FINANCIALS-PREV'!$B$5:$AB$3000,MATCH(1,($B9='FINANCIALS-PREV'!$B$5:$B$3000)*(D$8='FINANCIALS-PREV'!$B$5:$AB$5),0))}
can you provide a sample file with dummy data to work with?
{=INDEX('FINANCIALS-PREV'!$B$5:$AB$3000,MATCH(1,($B9='FINANCIALS-PREV'!$B$5:$B$3000)*(D$8='FINANCIALS-PREV'!$B$5:$AB$3000),0))}
arrays need to be same size
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks