+ Reply to Thread
Results 1 to 2 of 2

Search information in a db interval

  1. #1
    Registered User
    Join Date
    06-18-2019
    Location
    Brasil
    MS-Off Ver
    2016
    Posts
    5

    Search information in a db interval

    Good night,

    I have a problem with excel that I can not solve.

    I have a database (Columns K, L and M) and with it I need to fill my column C, as follow image:

    Sem_título.jpg

    I need a sort of VLOOKUP that looks for the range of column A and B in the range of column K and L to give me the value of M.
    In other words the range, for example from 0 to 31,254, is within which range of column K and L? In gives me type A.

    I can do a lot of "ifs" but the database is much larger than that of the image. I need a way to do this with some function.

    Does anyone know how to help me?

    Thank you

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,473

    Re: Search information in a db interval

    It appears to me that it should be a basic VLOOKUP() function with the approximate match option (4th argument of VLOOKUP() is TRUE or omitted). The approximate match behavior is described in the help file (https://support.office.com/en-us/art...8-93a18ad188a1 ), but almost all of the examples online are for the exact match option. Something like =VLOOKUP(A2,$K$2:$M$13,3,TRUE) will return A.

    Will that work for you? Is there more to the question?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Search/ look up information across multiple worksheets
    By nesswotr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-20-2017, 01:05 PM
  2. help with funtion to search for information, maybe VLOOKUP?
    By Chulo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-05-2014, 01:40 PM
  3. Replies: 1
    Last Post: 04-29-2014, 04:42 AM
  4. [SOLVED] How to make an interval and search for values within that interval?
    By gamoerma in forum Excel General
    Replies: 12
    Last Post: 10-13-2013, 10:33 AM
  5. Avg numbers in specified interval from non-interval data
    By weeble33 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-14-2013, 07:27 PM
  6. Replies: 5
    Last Post: 03-29-2013, 07:50 PM
  7. Search and select time interval in stock database
    By glanzy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-15-2013, 05:28 AM

Tags for this Thread

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

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.05628 seconds
  • Memory Usage 8,906KB
  • Queries Executed 16 (?)
More Information
Template Usage (33):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (2)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (2)postbit_legacy
  • (2)postbit_onlinestatus
  • (2)postbit_wrapper
  • (4)showthread_bookmarksite
  • (7)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php 

Hooks Called (49):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit
  • tag_fetchbit_complete
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1