=VLOOKUP('I-S 4COLUMN'!$B18,'2 YR INCOME STMT'!$A$4:$E$20,2,0)
Above is my vlookup formula. The spreadsheet '2 YR INCOME STMT' changes each month. How can I keep the formula constant when I change the spreadsheet '2 YR INCOME STMT' each month.
When I change the spreadsheet the formula changes to =VLOOKUP('I-S 4COLUMN'!$B11,#REF!$A$4:$E$20,2,0)
Can anyone help please?
Would something like this work:
=VLOOKUP('I-S 4COLUMN'!$B18,OFFSET('2 YR INCOME STMT'!$A$4,0,0,COUNTA('2 YR INCOME STMT'!$A:$E),COUNTA('2 YR INCOME STMT'!1:1)),2,0)
Last edited by BrownBoy; 09-18-2014 at 03:46 PM. Reason: Error in formula
BrownBoy
If happy, mark "SOVLED" & add to "REP"
changes to what?The spreadsheet '2 YR INCOME STMT' changes each month.
Perhaps put that in an INDIRECT() function and reference it?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks I have a fix.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks