compare formula
 

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"


--
rbmcclen
------------------------------------------------------------------------
rbmcclen's Profile: http://www.excelforum.com/member.php...o&userid=36367
View this thread: http://www.excelforum.com/showthread...hreadid=570871

compare formula
 

vlookup should do the trick


rbmcclen wrote:
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"


--
rbmcclen
------------------------------------------------------------------------
rbmcclen's Profile: http://www.excelforum.com/member.php...o&userid=36367
View this thread: http://www.excelforum.com/showthread...hreadid=570871