Probably the worst title possible, but its hard to describe. My issue is a simple VLOOKUP- but it needs a 3rd parameter- but I can't do a nested VLOOKUP cos the first column may be blank! Ready to pull out my hair.
So, here's an example:
Data!
Work | Person A | Profit1
_____| Person C | Profit2
_____| Person B | Profit3
_____| Person D | Profit4
Home | Person L | Profit5
_____| Person A | Profit6
School| Person X | Profit7
_____| Person B | Profit8
_____| Person A | Profit9
So, I want a cell on another page to print out data. So lets say I have it to give me person A profit at Home. If I do VLOOKUP('Person A',Data!A:C,3,FALSE) Excel gives me Profit 1. I want it to give me Profit 6. So I can nest it, but it will only do that if cells in Column A were all labeled. They're not-- and they're variable- some have 4 people, some have 2- so I can't use a offset.
Basically- I need it too look down the first column (place-home school work) find a variable, then start looking from that row down to find a person (personA) then print the corresponding profit.
It seems so easy, but that extra 3rd step without the ID's working in Column A has thrown me off. I have it working with a MATCH nested in an INDEX- but it fails because of the blanks in column A.
I realize this was a nightmare to read, but i'm running out of options here! Thanks!
Bookmarks