M
mr tom
Hi,
Happy New Year, all.
I need to lookup based on both of two conditions being satisfied.
We have a number of financial advisers in regional offices, and they are
ranked.
Given a rank and an office, I want to return the name of the adviser.
Don't worry about ranks that are too high or offices that don't exist.
I'm after something that says, if rank = 2 and office = London, return
Example Data List
Rank Name Office
1 Tom R Bath
2 Katy C Bath
3 Nigel G Bath
4 Pete R Bath
1 Tony A London
2 John B London
3 Mary C London
4 Jane D London
And so on down, although in reality the list is unsorted.
In this case, it would return "John B" as Rank 2 in London
Does this make any sense?
Cheers.
Happy New Year, all.
I need to lookup based on both of two conditions being satisfied.
We have a number of financial advisers in regional offices, and they are
ranked.
Given a rank and an office, I want to return the name of the adviser.
Don't worry about ranks that are too high or offices that don't exist.
I'm after something that says, if rank = 2 and office = London, return
Example Data List
Rank Name Office
1 Tom R Bath
2 Katy C Bath
3 Nigel G Bath
4 Pete R Bath
1 Tony A London
2 John B London
3 Mary C London
4 Jane D London
And so on down, although in reality the list is unsorted.
In this case, it would return "John B" as Rank 2 in London
Does this make any sense?
Cheers.