[MS Excel Help] Comparisons and searchs

[menorton]

i have a question with MS Excel. I have two columns, and i want excel to look at all of the values in column A, and if any of the values are in Column B, place a "Sold" value in respective row of Column C. So if value text-value 5555 on Row 10 of Column A is present anywhere in Column B, in the respective row of column c (row 10), there will be a "Sold" value. This looks like to be an IF statement, but not sure how to frame it.

the values i have to search for in clumn B from Column A are not numberical, so the A1>b1 will make no sence. They are numbers, but not numerical, they are being used as texts since the values are for identificational purposes. Thus, excel must use do a search or find function command.



any hints?

 

[WW]

enter this in column c1, and copy it down

=IF(COUNTIF(B:B,A1)>=1,"sold","")

 

[LordSnailz]

hrmmm, what does B:B represent? the span of the column B?

 

[KLin]

Originally posted by: LordSnailz
hrmmm, what does B:B represent? the span of the column B?

It's a range that contains column B.

 

[WW]

yep..all of column B....then you don't have to rename the range if you add more to column B (B1:B100...now B1:B110...etc)