Need Expert Excel Help_applying Index & Match Formula To Two Rows Data -

nickkan
Dear Members-
Need help with worksheet. Spent half a day but havent got any solution. Attached is motor vehile worksheet with two tabs. 1) Result 2) Data. Data is the tab which we download from our accounting system. And result is the tab where I need to abstract data from data tab. I will try to explain what I want. Say in cell Z9 of results tab I want 300 as result and in cell ad9 i want 658 as result. It will be abstract from data sheet.. ie looking at Z5 (Account code) and G9 (Registeration No).
So I am sure lookup will not work in this situation. What will work is combination of index and match again the problem with that is index formula apply to rows and columns but in my case both are rows. Another twist is in data sheet account code is full account no but I want to look it only in last five digits only. without adding an additional column in data sheet.
Hope I explained it properly. Looking forward to solution. Thanks in advance
1 Attachment(s) [Login To View]

kraviravi.kravi@gmail.com
hi friend,
i have gone through your sheet and as per my calculation it is a difficult task involving functions of row, multiple vlook up , immediately i am not in a position to help you, hence will suggest you these websites wherein you will get the help immediately
Excel Templates | Excel Add-ins and Excel Help with formulas and VBA Macros
<link outdated-removed> ( Search On Cite | Search On Google )
nickkan
thanks mate- I have gone through some of sites online but havent got my answer. But i will have a look at your link. Thanks for taking time to look at. Cheers Nav
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute