Results 1 to 5 of 5

IF function to find an item within a range.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-03-2008
    Location
    Northern Ireland
    MS-Off Ver
    2003
    Posts
    107

    IF function to find an item within a range.

    Hi all,

    I'd like an if function to display "Yes" when a postcode is found within a range of postcodes.

    For example if I have BT23 4RE in cell b1 and a range of postcodes from say cell a1:a76 which has BT23 4RE in it, it will display yes.
    Last edited by Steve-B; 03-10-2009 at 01:00 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1