| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible? | Excel Worksheet Functions | |||
| Urgent - How to using formula to compare 2 worksheets | Excel Worksheet Functions | |||
| Formula to compare a cell to find same value in a column in Excel | Excel Worksheet Functions | |||
| Formula to compare two lists and separate non-recurring items? | Excel Worksheet Functions | |||
| How do I write formula to compare two values and pull the resulta. | Excel Worksheet Functions | |||
Threaded Mode
