Compare a string in two columns, if match then append string from third column

**Londonderry** · 02-22-2007, 02:37 PM

In sheet 1, I have a long list of part numbers in column A.

In sheet 2, I have two columns with an even longer list of part numbers in column A, and the part name in adjacent column B.

I want to check to see if the part number is listed in both sheets, and if it is, take the part name from sheet 2 and place it in the cell in sheet 1... any suggestions?

**VBA Noob** · 02-22-2007, 02:40 PM

Hi,

How about vlookup

http://www.contextures.com/xlFunctions02.html

VBA Noob

**Londonderry** · 02-22-2007, 03:36 PM

I'm getting a lot of #REF cells... would this have anything to do with the range being a combo of both decimal part numbers such as 2342.34234 along with things like HGI-448 7GH?

**VBA Noob** · 02-22-2007, 03:41 PM

Post an example and someone will take a look for you

VBA Noob

Compare a string in two columns, if match then append string from third column

LinkBack

Thread Tools

Rate This Thread

Display

Compare a string in two columns, if match then append string from third column

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions