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

**coachhandy** · 08-20-2013, 07:38 PM

I have two sheets in a file. Sheet 1 and Sheet 2 both have an "item number field" I need to return the value next to the item number in Sheet 2 to have it arrive next to the item number in Sheet 1. There are about 600 items in Sheet 1 but only 400 items in Sheet 2.

**jeffreybrown** · 08-20-2013, 07:44 PM

Hello & Welcome to the Forum,

Try a VLOOKUP

=VLOOKUP(A2,Sheet2!$A$2:$B$26,2,0)

**coachhandy** · 08-20-2013, 07:58 PM

I appreciate your post! I am trying to make that work now. Thanks Jay

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Lookup two item code and package size, return price for match

[SOLVED] Two Excel sheets trying to match text data and return the match from the second column!

Finding item # match on multiple sheets

Formula to Match columns in separate sheets

Match return #NA ...though item exists!

Bookmarks

Bookmarks

Posting Permissions