+ Reply to Thread
Results 1 to 6 of 6

Matching Item numbers in two different worksheets using item description

  1. #1
    Registered User
    Join Date
    08-22-2008
    Location
    cayman islands
    Posts
    5

    Matching Item numbers in two different worksheets using item description

    Hi,

    I'm trying to match item numbers in the inventory tab with the item numbers in the BT tab using the description title as the common thing. I have added a column called BT Itme number on Inventory tb as this is where i want to display the item number from BT tab.

    Problem is the description details in Inventory tab is different from the description in BT tab.

    I'm trying to get a formula that allows e to do this without doing it row by row (item by item) like i have done on cell D34 & D49 on Inventory tab.

    Appreciate any assistance.

    Regards,
    Lidoxy
    Attached Files Attached Files

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,178

    Re: Matching Item numbers in two different worksheets using item description

    How about...

    =INDEX(BT!$A$2:$A$255,MATCH(C34,BT!$B$2:$B$255,0))

    What version of Excel are you using?

    If 2007 you can use Iferror to return a zero

    =IFERROR(INDEX(BT!$A$2:$A$255,MATCH(C34,BT!$B$2:$B$255,0)),0)

    2003

    =IF(ISNA(INDEX(BT!$A$2:$A$255,MATCH(C34,BT!$B$2:$B$255,0))),0,INDEX(BT!$A$2:$A$255,MATCH(C34,BT!$B$2:$B$255,0)))
    Last edited by jeffreybrown; 07-26-2011 at 09:11 PM.
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    08-22-2008
    Location
    cayman islands
    Posts
    5

    Re: Matching Item numbers in two different worksheets using item description

    Thanks Jeff.

    I'm using excel 2003.

    With the 1st formula, i got #NA, with the 2nd formula i got #Name? and with the 3rd formula i got 0. Only cell D6 and D34 return a value that's close to what i am looking for (486), but this is the item number for the corona.

    Thanks,
    Lidoxy

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,178

    Re: Matching Item numbers in two different worksheets using item description

    What's wrong with this.

    Please tell me what you expect that is not here?
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    08-22-2008
    Location
    cayman islands
    Posts
    5

    Re: Matching Item numbers in two different worksheets using item description

    Quote Originally Posted by jeffreybrown View Post
    What's wrong with this.

    Please tell me what you expect that is not here?
    Thanks Jeff - nothing is wrong with the formulae. Just wondering if there's anything i can do to make say cell D14 return value 281 for the sam adams lager description. Or do the descriptions have to have the same characters?

    Thanks again,
    Lidoxy

  6. #6
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,178

    Re: Matching Item numbers in two different worksheets using item description

    Yes they need to match.

    You could try Fuzzy Matching

    I've never actually used this for my purposes, but I know it works.

    You may have to play with the layout of your data, but if you get stuck maybe either somebody here has some ideas or you can reply to the thread above.

+ Reply to Thread

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

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.07004 seconds
  • Memory Usage 9,002KB
  • Queries Executed 15 (?)
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)bbcode_quote
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (6)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (2)postbit_attachment
  • (6)postbit_legacy
  • (6)postbit_onlinestatus
  • (6)postbit_wrapper
  • (4)showthread_bookmarksite
  • (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 (47):
  • 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_attachment
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1