compare formula

  • Thread starter Thread starter rbmcclen
  • Start date Start date
R

rbmcclen

Hi all, thanks in advance for the help,

What I want to do is display the protocol of a given port to its common
protocol. So what I want to have is a column listing common ports (21,
22, 25, 53, etc) and a column listing their common protocols (FTP, SSH,
SMTP, DNS, etc).

Then, have a cell (say, A2) check the value of another cell (A1) and
display the appropriate protocol.

So, if I were to type a number into Cell A1, say '666', then cell A2
would compare that value to the list and display "Doom"
 
Back
Top