# Matching Item numbers in two different worksheets using item description

1. ## 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

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

=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)))

3. ## 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. ## 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?

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

Originally Posted by jeffreybrown
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. ## 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.

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

#### 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 (?)
Template Usage (33):
• (1)bbcode_quote
• (1)footer
• (1)forumrules
• (1)gobutton
• (6)memberaction_dropdown
• (1)navbar
• (4)navbar_noticebit
• (6)option
• (2)postbit_attachment
• (6)postbit_legacy
• (6)postbit_onlinestatus
• (6)postbit_wrapper
• (1)spacer_close
• (1)spacer_open
• (1)tagbit_wrapper

Phrase Groups Available (6):
• global
• inlinemod
• postbit
• posting
• reputationlevel
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
• ./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_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_foruminfo
• global_state_check
• global_bootstrap_complete
• global_start
• style_fetch
• global_setup_complete
• friendlyurl_redirect_canonical
• bbcode_fetch_tags
• bbcode_create
• postbit_factory
• postbit_display_start
• 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