View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ggant
 
Posts: n/a
Default If columns match

Is there a formula that I can use to see if numbers (some are Alphanumeric)
match. ie

A B
5 7
9 4
7 1

I want colums A3 and b1 to say they match and display Y in column C on
either line.