i have a data is export from accounting software, the data i need is not in the same row. can i have a formula that can help me lookup the data and create a new table for me?
Please refer to the attachment. thanks very much.
i have a data is export from accounting software, the data i need is not in the same row. can i have a formula that can help me lookup the data and create a new table for me?
Please refer to the attachment. thanks very much.
Last edited by choy96; 01-28-2024 at 09:17 PM.
Assuming you are still using Excel 2019: 3 formulae. Please refer to the file.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Thank you very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks