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)

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,"")

MIKE

You can't use an IF to find values over a range of cells. Try VLOOKUP.

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 thisHow-To.

Ask Your Question

Weekly Poll

Do you trust smart speakers to not spy on you?

Discuss in The Lounge

Poll History