LinkBack URL
About LinkBacks
I'm trying to get Cell Q385 to give me 6,647... Is my formula a bust?
6,647 is found in cell G426 on the 'RM backlog' sheet
=IFERROR(INDEX('RM Backlog'!$G$2:$G$1048576,MATCH($D382&Q$8,'RM Backlog'!$F$2:$F$1048576&'RM Backlog'!$E$2:$E$1048576,0)),0)
I'm trying to get Cell Q385 to give me 6,647... Is my formula a bust?
6,647 is found in cell G426 on the 'RM backlog' sheet
=IFERROR(INDEX('RM Backlog'!$G$2:$G$1048576,MATCH($D382&Q$8,'RM Backlog'!$F$2:$F$1048576&'RM Backlog'!$E$2:$E$1048576,0)),0)
You could put a column K on the backlog sheet with the formula =F2&E2 copied down. Then you could modify your formula in Q385 of the Summary sheet to read:Let us know if you have any questions.Formula:
Please Login or Register to view this content.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
It works! Thank you, JeteMc!! You're a genius....
You're Welcome. Thank you for the generous feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks