View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Xhawk57 Xhawk57 is offline
external usenet poster
 
Posts: 25
Default Find if there is a matching number in another column

is there a way to take two sets of data and mark a third column when the
number from the fist column has a match anywhere in the set (range) of data
for the other column?

for instance i have 3 columns

A B C
1 9
3
9
4

is there a formula that would return a marker in column C by asking the
question "if B1 = any number in column A return an "X""?