Match Text in two worksheets

December 15, 2010 at 10:51:21
Specs: Excel 2003
Basically I have two worksheets that have a common range data (Text). I am trying to match data in one worksheet to the same data in the other worksheet. Once a match is found then additional data (Text) currently in one of the workseets is recorded in the other worksheet that did not previously have this additional data. Below is the formula i used without success.

=IF(A2='PT Vendor List'!$A$2:$A$748,'PT Vendor List'!$B$2:$B$748,0)

See More: Match Text in two worksheets

December 15, 2010 at 11:57:53
Not completely sure but I think this should work:

=IF(ISERROR(MATCH(A2,'PT Vendor List'!$A$2:$A$748,0)),'PT Vendor List'!B2,"")


Report •

December 15, 2010 at 12:03:11
You can't use an IF to find values over a range of cells.


Assuming you are trying to match values in Column A and return the value from Column B, try something like this.

Note: Since I can't see your worksheet from where I'm sitting, I might not have the formula exactly correct. Review the Excel Help files for VLOOKUP to see if it sounds like what you need.

VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

=VLOOKUP(A2, 'PT Vendor List'!$A$2:$B$748, 2, 0)

This will look through 'PT Vendor List'!$A$2:$A$748 for the value in A2 and return the value from the second column of 'PT Vendor List'!$A$2:$B$748, which is column B.

If the value isn't found it will return #N/A, which can also be dealt with. However, before we get into that, determine if VLOOKUP will fit your needs.

Posting Tip: Before posting Data or VBA Code, read this How-To.

Report •
Related Solutions

Ask Question