View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cthompson17 cthompson17 is offline
external usenet poster
 
Posts: 3
Default Comparing 3 columns?

How do I compare a value in one cell, to a value in a column, that looks at
the value in the adjacent column, to display in a cell?

For example: cell A1 = cindy; column B in cell B17 = cindy; and in the
adjacent cell, column C17 = 777. I would like the value of cell C17 to
display in a cell.

Does anyone know how to do this?