On 08/10/10 15:00, Brad Rogers wrote:
Hello All,I'm trying to get text printed in a cell in Calc based on the values found in other cells, as follows; Col1 Col2 Row1 Cat 2 Row2 Dog 4 Row3 Mouse 3 The text I want to output to the result cell is from Col1, based on the values in Col2. Specifically, the lowest value. SO, in this instance, I'd like "Cat" as the o/p.
Is vlookup() of any help? It seems in the right sort of direction........ -- Mike Scott Harlow, Essex, England --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
