Results 1 to 14 of 14

Isnumber(search results misleading

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-16-2012
    Location
    Sefton
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    158

    Isnumber(search results misleading

    I've got a table 24x24 (excluding headers) the row and column headers will change depending on entries elsewhere in the workbook.
    The column headers will either be single or double numbers - 1 / 2 / 3 / 4 / 5 or 1,2 / 3,4 / 5,6 / 7,8 / 9,10 or a combination - 1 / 2 / 3,4 / 5,6 etc
    The row headers will be a list of the numbers - 1,2,3,4,5,6 / 3,4,9,10 / 1,2,5,6,9 etc.

    My table is set out to show if the row header contains the column header and if so will show TRUE, if not FALSE.

    The problem i'm having is when there's numbers over 10 or 20 etc the table will show true if the column headers have 1 or 2 as options.
    Is there anyway for these to be discounted if the column header numbers aren't 1 or 2 and are 10s or 20s?

    Sorry, i should say - numbers can appear on their own in both headings, when listed with another there will be a comma between them (no space)
    Last edited by DHFE; 11-02-2015 at 11:04 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] if isnumber search problem
    By rookie284 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-18-2014, 11:32 AM
  2. How many values can be in IF(ISNumber(search
    By aurness in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-25-2013, 11:11 PM
  3. [SOLVED] =IF(ISNUMBER(SEARCH Problem
    By 3smees23 in forum Excel General
    Replies: 3
    Last Post: 11-09-2012, 10:54 AM
  4. If, or, isnumber, search
    By reb2u in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-15-2012, 10:53 AM
  5. Multiple IF ISNUMBER SEARCH
    By bibach in forum Excel General
    Replies: 5
    Last Post: 07-13-2011, 04:41 AM
  6. Isnumber(search
    By AVIDDA in forum Excel General
    Replies: 1
    Last Post: 01-14-2011, 02:45 PM
  7. [SOLVED] Reverse Vlookup multiple results if isnumber?
    By Jmarsh4 in forum Excel General
    Replies: 2
    Last Post: 05-13-2010, 04:54 PM

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