Global Mod Team
Join Date: Nov 2002
Location: Congleton - The centre of
OK, I need some assistance but the data is sensitive, so I have to try to describe rather than showing you!
Column A has an 'identifier'.
Column F has the information I want.
I want to have a summary tab which pulls this data out.
Normally, I would use a VLOOKUP of course, saying, find identifier 'x' in column A, return the value in column F.
Column A has duplicate values, because there are subsets within that identifier. so 'x' might have 3 rows related to it, and only one of those rows will have the value I'm trying to return.
Column C has the 'subset identifier', if that helps.
So, if I have something that looks like this:
column A . . . Column C . . . Column F
x . . . 1 . . . blank
y . . . 2 . . . value
z . . . 3 . . . blank
How do I write a formula which will return the value for me?
"Human beings, who are almost unique in having the ability to learn from the experience of others, are also remarkable for their apparent disinclination to do so." - Douglas Adams
"You know, sometimes the world seems like a pretty mean place."
"That's why animals are so soft and huggy."
- Calvin and Hobbes
To err is human, to moderate ursine.