Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Ok, I just cant seem to find a way to do what I want.
I have a table that contains the first 3 digits of a large number of zip codes similar to the following 16 103 199 17 104 200 18 105 202 19 106 203 20 107 204 21 108 205 22 109 207 23 110 208 This table is on a seperate tab. What I want to do is enter a value in a cell and have the formula determine if the number is in the table. If it is I need the cell to say "Yes" if not then say "No". Am I missing something simple? Thanks for the help. -- Brooks W. |