LinkBack URL
About LinkBacks
=HLOOKUP(D$2,'P&L'!$5:200,136-5+1,FALSE)
I am working on a personal financial statement and looking at my friends model. Why does the row_index_number have addition and subtraction in it? I am very lost about it.
=HLOOKUP(D$2,'P&L'!$5:200,136-5+1,FALSE)
I am working on a personal financial statement and looking at my friends model. Why does the row_index_number have addition and subtraction in it? I am very lost about it.
HLOOKUP( value, table_array, index_number, [not_exact_match] )
=HLOOKUP(D$2,'P&L'!$5:200,136-5+1,FALSE)
table_array = 'P&L'!$5:200 (incorrect), something like 'P&L'!A$5:C200
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
Although acceptable you are reffering to 195 whole rows and 136-5+1 can be replaced by 132
So
=HLOOKUP(D$2,'p&L'!$E5:E200,136-5+1,FALSE)
Shoudl work
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks