nickkan
1

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

From Australia, Perth
Attached Files (Download Requires Membership)
File Type: xls Motor Vehicles.xls (39.9 KB, 501 views)

kraviravi.kravi@gmail.com
113

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 )

From India, Madras
nickkan
1

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
From Australia, Perth
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.