Conditional formatting idea but with the outcome of a value not font/colours

[tlacloche]

Hello,

is there a way to have a cell input a particular value because another cell had a particular value?
sorry for the terrible explanation...

for example
in column A, there are:
A1: Apples
A2: Bananas
A3: Oranges
A4: Apples

i want cells in column B to give a number based on the fruits in column A. so the number 26 if its Apple; 42 if its Bananas; 61 if its Oranges;

so column B will look like:
B1: 26
B2: 42
B3: 61
B4: 26


hope that makes sense.
thanks

[Mayda89]

Yes, there is a way to do this. First, you need to have a range consisting of two columns, with fruit names on the left column and the number code on the right column. Lets call this range MyRange.

Now, in the cell where you want the lookup information (i.e. the number code) to be displayed, write this formula
(substitute MyRange with the appropriate range and dont forget to use dollar signs to fix this range)

Please Login or Register  to view this content.

You can copy this formula down.

[tlacloche]

thanks buddy

[Mayda89]

You're welcome