Conditional Results

[Bill]

I want to compare a cell's value against a list of possible criteria (up to 30) and write a result based on the match to the criteria. For example

if value of a1 is 1, compare that to the list of criteria of 1, 2, 3, 4, 5.....10. Write result of "Blue" since a1 finds a match of "1". This process needs to repeat for a2, a3, a4 etc. all compared to the same list of criteria so that it does not need to be recreated for each line (a2....a100

Can this be done with functions? I'm not a VBA writer

Thanks

 

[Frank Kabel]

Hi
lets say your list of criteria is in the range X1:X10 then enter the
following formula in B1
=IF(COUNTIF($X$1:$X$10,A1)>0,"Blue","")
and copy this down for all rows

 

[Bill]

Thanks for the reply. I did not explain this well enough.

Assume column A is a text string that represents a product name (prod1). Column B represents a list of 30 possible products to sell. Column C represents the price for each product. I need to compare the text value of "prod1" against a list of possible mathces ("Prod1" thru "prod30") . If I find a match for "Prod1", I want to write the numeric price associated with that part.

Thanks in advance for your help.

 

[Frank Kabel]

Hi
try
=VLOOKUP("prod1",B1:C100,2,0)