Results 1 to 4 of 4

OR MATCH only returns FALSE when using a table array

Threaded View

  1. #1
    Registered User
    Join Date
    02-15-2013
    Location
    louisville
    MS-Off Ver
    Excel 2007
    Posts
    4

    OR MATCH only returns FALSE when using a table array

    I am comparing fields on multiple sheets. When I use =OR(ISNUMBER(MATCH(B3,KNDQA!B28:M29,0))) to match a value on a separate sheet it always returns FALSE regardless of the exact match or not. I am not sure what the issue is. It only returns true if my array is a single cell.

    Please help!

    Feb_13_all_universes.xlsx
    Last edited by scottyperry; 02-15-2013 at 01:10 PM. Reason: attaching file

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