Using If statement to link item number and item from two different sheets

**jaylahaye1974** · 10-14-2015, 09:28 AM

Hi All,

I'm stuck, I've done this in the past but I'm at a loss to on how to make this work.

I have a list of item #'s that tie to a name of item. I need that name to come up on another sheet whenever that item number is used.

How would I go about setting this up? Thanks for the help in advance!

**Mazzaropi** · 10-14-2015, 09:43 AM

jaylahaye1974, Good morning.

You can use a different ways to do this using Excel.

Vlookup, Hlookup, Index + Match and etc...

It's necessary to know your file to advise you in a conclusive way.

Please attach an example of your file here.

Using If statement to link item number and item from two different sheets

LinkBack

Thread Tools

Rate This Thread

Display

Using If statement to link item number and item from two different sheets

Re: Using If statement to link item number and item from two different sheets

Thread Information

Users Browsing this Thread

Similar Threads

For same item number, identify difference in item description for different location

Pulling an entire row of data from an item list by entering just the item number

Link and Item number to a Name...

UserForm: Search Item in List > Call Table associated with Item > Execute Command

Searching Item Code And Item Number

Needing to Match item number in two separate sheets and return a value

Auto-incrementing item reference number over multiple sheets

Bookmarks

Bookmarks

Posting Permissions