Results 1 to 11 of 11

List data base having one field as title

Threaded View

brunces List data base having one... 09-15-2016, 01:25 PM
JeteMc Re: List data base having one... 09-15-2016, 05:25 PM
kvsrinivasamurthy Re: List data base having one... 09-16-2016, 04:48 AM
brunces Re: List data base having one... 09-16-2016, 07:50 AM
JeteMc Re: List data base having one... 09-16-2016, 09:28 AM
brunces Re: List data base having one... 09-16-2016, 10:16 AM
JeteMc Re: List data base having one... 09-16-2016, 10:24 AM
brunces Re: List data base having one... 09-16-2016, 10:39 AM
JeteMc Re: List data base having one... 09-16-2016, 10:41 AM
brunces Re: List data base having one... 09-16-2016, 10:46 AM
JeteMc Re: List data base having one... 09-16-2016, 12:14 PM
  1. #9
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,897

    Re: List data base having one field as title

    I don't know why the ...IF(OR(... was throwing a #NAME? error however it isn't now. I got rid of that last IFERROR as it appears to be unnecessary. This seems to be working:
    Formula: copy to clipboard
    =IF(J5=1,"",IFERROR(INDEX(C:C,MATCH(J5,A:A,0)),IF(OR(IFERROR(K4=INDEX(B:B,MATCH(J5+2,A:A,0)),FALSE),ISERROR(MATCH(J5+2,A:A,0))),"",INDEX(B:B,MATCH(J5+2,A:A,0)))))
    Let me know if you have any questions.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How do I base the value of one field, conditionally on another.
    By Darth269 in forum Access Tables & Databases
    Replies: 4
    Last Post: 06-20-2013, 08:15 AM
  2. Help Creating a List from a large data base with repeating information
    By KelliB in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-17-2013, 04:09 PM
  3. Macro to reorganize Columns base on Title
    By nkf531 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-24-2012, 01:52 PM
  4. Auto fill from data base drop down list
    By ciapul12 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-03-2011, 08:45 AM
  5. runtime error 1004 data base or list range not valid
    By jay11 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-17-2010, 03:08 PM
  6. Formula for making a list from data base
    By nelliev8 in forum Excel General
    Replies: 2
    Last Post: 06-24-2010, 09:19 PM
  7. Replies: 1
    Last Post: 01-12-2006, 06:00 PM
  8. I want to link my order form with my data base list
    By shorty in forum Excel General
    Replies: 0
    Last Post: 08-31-2005, 02:05 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