CODEWITHSUNDEEP
excelexcel-2010
Alex
Alex

Reputation: 1733

Compare Worksheets

I have two Worksheets (WS) in one Excel document:

WS1

FIRST NAME     LAST NAME

WS2

FIRST NAME     LAST NAME     ID

I'm looking to add a column in WS1 named MATCHED ID.

MATCHED ID would display (below pseudo code result):

(WS1:FIRST NAME + WS1:LAST NAME) COMPARE AGAINST ALL WS2 (WS2:FIRST NAME + WS2:LAST NAME) IF EQUALS (WS1:MATCHED ID).

Any help is appreciated. Thanks.

Upvotes: 0

Views: 47

Answers (1)

nwhaught
nwhaught

Reputation: 1592

Add a new column (to the left of your data) on both sheets called FULL_NAME, which is =CONCATENATE(FIRST_NAME,LAST_NAME)

Then on WS1, MATCHED ID is =VLOOKUP(WS1!FULL_NAME,WS2![RANGE],[ID COLUMN],0)

Upvotes: 1

Related Questions