Dear Members,
I need help with a worksheet. I have spent half a day but haven't found any solution. Attached is a motor vehicle worksheet with two tabs: 1) Result and 2) Data. The Data tab is where we download information from our accounting system, and the Result tab is where I need to extract data from the Data tab. Let me try to explain what I need. For example, in cell Z9 of the Results tab, I want the result to be 300, and in cell AD9, I want the result to be 658. This data will be extracted from the Data sheet by looking at Z5 (Account code) and G9 (Registration No).
I am aware that a simple lookup function may not work in this situation. What could work is a combination of the index and match functions. The challenge I am facing is that the index formula typically applies to rows and columns, but in my case, both the Account Code and Registration No are in rows. Another complication is that in the Data sheet, the Account Code is the full account number, but I only want to consider the last five digits without adding an additional column to the Data sheet.
I hope I have explained this clearly. I am looking forward to a solution. Thank you in advance.
From Australia, Perth
Acknowledge(0)
Amend(0)
1I need help with a worksheet. I have spent half a day but haven't found any solution. Attached is a motor vehicle worksheet with two tabs: 1) Result and 2) Data. The Data tab is where we download information from our accounting system, and the Result tab is where I need to extract data from the Data tab. Let me try to explain what I need. For example, in cell Z9 of the Results tab, I want the result to be 300, and in cell AD9, I want the result to be 658. This data will be extracted from the Data sheet by looking at Z5 (Account code) and G9 (Registration No).
I am aware that a simple lookup function may not work in this situation. What could work is a combination of the index and match functions. The challenge I am facing is that the index formula typically applies to rows and columns, but in my case, both the Account Code and Registration No are in rows. Another complication is that in the Data sheet, the Account Code is the full account number, but I only want to consider the last five digits without adding an additional column to the Data sheet.
I hope I have explained this clearly. I am looking forward to a solution. Thank you in advance.
From Australia, Perth
Acknowledge(0)Amend(0)
Hi friend,
I have gone through your sheet, and as per my calculation, it is a difficult task involving functions of rows, multiple VLOOKUPs. Currently, I am not in a position to help you. Hence, I will suggest these websites where you can get immediate assistance:
- [Excel Templates | Excel Add-ins and Excel Help with formulas and VBA Macros](http://www.ozgrid.com/)
- [link outdated-removed] ([Search On Cite](https://www.citehr.com/results.php?q=Excel%20Help%20Forum) | [Search On Google](https://www.google.com/search?q=Excel%20Help%20Forum))
I hope these resources will be helpful to you.
Best regards, [Your Name]
From India, Madras
Acknowledge(0)Amend(0)
I have gone through your sheet, and as per my calculation, it is a difficult task involving functions of rows, multiple VLOOKUPs. Currently, I am not in a position to help you. Hence, I will suggest these websites where you can get immediate assistance:
- [Excel Templates | Excel Add-ins and Excel Help with formulas and VBA Macros](http://www.ozgrid.com/)
- [link outdated-removed] ([Search On Cite](https://www.citehr.com/results.php?q=Excel%20Help%20Forum) | [Search On Google](https://www.google.com/search?q=Excel%20Help%20Forum))
I hope these resources will be helpful to you.
Best regards, [Your Name]
From India, Madras
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
EXCEL FORMULA.xls
10 ways to format Excel data.pdf