View Single Post
  #1  
Old June 7th, 2010, 03:37 PM
thefreckles thefreckles is offline
Member
 
First recorded activity by OfficeFrustration: Apr 2008
Posts: 4
Default Looking up and matching data in different worksheets

Hi! I have two sheets in a workbook. In Sheet 1 I need to match the data in Column G plus the data in Column F to the data in Column C in Sheet 2. Any matches then need to return the data that is in Column A on Sheet 2 to Column J on Sheet 1.

e.g.

Sheet 1
Column F - First Name
Column G - Surname
Column J - (need to insert ID from Sheet 2)

Sheet 2
Column A - ID number
Column C - Surname, First Name

So Column J in Sheet 1 needs to look up the data in Column G (Surname) and then Column F (First Name), then look for matches in Column C (Surname, First Name) of Sheet 2 and then return in Column J Sheet 1 the data in found in Column A Sheet 2 (ID Number) for those matches.

e.g. Sheet 1 Column F is 'Peter', Column G is 'Smith'; I want Excel to find 'Smith, Peter' in Sheet 2, Column C, and then look for his ID in Column A, Sheet 2. This ID number should then be returned to Column J in Sheet 1 (for said Peter Smith).

I hope that makes sense! I have no idea how to go about it though. Any help much appreciated!