Forum Discussion
Lookup from Bottom cell to Top cell
Unfortunately, it's not possible to change the data source format as my colleagues would refuse that. It's prepared in Excel and pasted into Outlook. However, as I have gathered from all your comments that It's really difficult to perform such a task, I have come up with my own solution. It's not ideal and requires lots of labor which is against Excel's nature and I wanted to avoid that and that's why I asked you experts to step in. My observation has been that in programming, there is always a solution to everything but It's not always that easy.
My solution:
Since the data source will always be in the same format, I'm creating direct cell references in another sheet and organizing the table in a vlookup or index match friendly way. It's a lot of work and not really ideal but it's a solution.
Thank you for your response. I really appreciate you taking your time to give a detailed answer. I didn't realize that I wasn't clear enough. So I've just edited my post with clearer explanation. I didn't actually format anything. It just how the source data is prepared. I just copied it as is. I only created sheet 2 to demonstrate what I need.
I was just lazy to change all the names 🙂 They will all of course have different names. So we can assume every employee is unique.
- I don't get it. You're lazy and you expect someone else to use their time to help you.
If you want help, provide a real example of the data taken directly from the email message. You also need to confirm that the layout will be IDENTICAL each time a new email with the data is received.- I didn't think It'd matter that's why I was lazy. But I should have made it clearer. You are right. It's important not to skip these kinds of details. I was just too much focused on my point of view rather than what others would think. Since I'm know every detail about my job, I couldn't think that someone would need that kind of detailed. I was wrong.
Yes the layout will be identical every time a new e-mail is sent.