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.
You've had 67 views, but not a single reply. And this one isn't really an answer to your question. Rather, it's a suggestion that you start over and make far more clear what it is that you're trying to do.
I need to lookup the value(will be located at the top) of a cell that is located at the bottom.
Huh?! That sentence alone makes no sense. Could you give the specific here...what is the value, and where is it? Which value that is "at the top of a cell at the bottom"--??
I will offer one observation that is extremely important: you have spent a LOT of time making this spreadsheet colorful; some might call it "pretty," which might be appropriate at some point. But of greater importance is creating something that, you know, actually works, actually functions. Leave the fancy coloring and formatting till a later step; once it works.
You can help us help you by backing up and describing what the purpose is that's being served here.
- What is the big picture into which this fits?
- What is the spreadsheet supposed to include?
- Where does data come from in the first place?
- What's supposed to happen with it?
- That kind of information.
- Based on your question, you appear to be wanting to do something more than just have a pretty sheet to hang on a bulletin board somewhere. But what is that bigger something?
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.
- What is to be done with Employee 4 who appears in ALL groups, BOTH shifts and ALMOST EVERY Lunch time.
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.
