Conditional or Indirect fill up

[FC]

I'm trying to get a formula ( 1st choice) or conditional formating that will
do this :
When writing a number or text in A1 for example, another word of my choice
will fill B1. No macros unless there is no other choice please. Thanks.

 

[Teddy-B]

In B1 type the formula

=IF(A1>0,"yes","")

In this case I chose the word "Yes" as the word of your choice.

 

[FC]

Thanks Teddy-B, but A1 ( or column A) will have different
names or numbers and then B1 ( column B ) will change accordinly.
ej. A1 orange - B1 navels
A2 5228 - B2 apples
A3 grapes - B3 small. Thanks

 

[Gord Dibben]

Sounds like you could use a lookup table and some VLOOKUP formulas in column B.

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html

Note the section on using DV lists from another worksheet by naming the list.


Gord Dibben MS Excel MVP

 

[FC]

Thanks Gord Dibben, but all cells in column A will change frecuentely and as
I change them I want B to change accordinly too. Also is too much information
for a dropdown list ( the changing words or numbers ). TX

 

[Gord Dibben]

OK forget the DV dropdowns, but the lookup table should work for you.

Unless you are entering words in column A that wouldn't be on any table.

Table on sheet2 in A1:B3 or any range you like.

Column A contains your words to enter.........orange, 5228, grapes

Column B contains your words to appear..........navels, apples, small

In B1 of sheet1 enter =VLOOKUP(A1,Sheet1!$A$1:$B$3,2,FALSE)

In A1 of sheet1 enter orange and see what is returned to B1


Gord