A
Andrew
Hi there,
I have three colums of data in a worksheet from A1 to C5, example;
Column A Column B Column C
ABC 5/2/10 02:00 Dog
DEF 5/2/10 02:15 Cat
ABC 5/2/10 03:47 Mouse
GHI 5/2/10 01:20 Bird
ABC 5/2/10 00:11 Horse
What I need to do in a seperate worksheet in A1 is to look up a value in
column A, find its lowest figure in column B and return the corresponding
value from column C. Then in A2 vlook up the same value in column A, find the
SECOND lowest figure in column B and return the corresponding value from
column C. Then in A3 the same but returning the THIRD lowest figure and on
and on. So using the example above with ABC as the look up value the results
would look like;
Horse
Dog
Mouse
Any help with this very appreciated. Thanks.
I have three colums of data in a worksheet from A1 to C5, example;
Column A Column B Column C
ABC 5/2/10 02:00 Dog
DEF 5/2/10 02:15 Cat
ABC 5/2/10 03:47 Mouse
GHI 5/2/10 01:20 Bird
ABC 5/2/10 00:11 Horse
What I need to do in a seperate worksheet in A1 is to look up a value in
column A, find its lowest figure in column B and return the corresponding
value from column C. Then in A2 vlook up the same value in column A, find the
SECOND lowest figure in column B and return the corresponding value from
column C. Then in A3 the same but returning the THIRD lowest figure and on
and on. So using the example above with ABC as the look up value the results
would look like;
Horse
Dog
Mouse
Any help with this very appreciated. Thanks.