If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|