LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default Looking up a value

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 12:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"