Malcolm Gill
New Member
- Joined
- Nov 26, 2016
- Messages
- 18
I have worksheets in two workbooks each with columns including forename and surname. If the person exists in workbook 2 then he/she will definitely be in workbook 1.
In workbook 2 I need a formula in the cells of column A which finds matches of forename and surname in workbook 1 and copies “mem_no” from worksheet 1 to worksheet 2.
Each column of data represents column A, B C etc.
Single value matching with VLOOKUP I can cope with but not 2 columns.
Can someone help?
Worksheet 1 example
<tbody>
</tbody>
<tbody>
</tbody>
In workbook 2 I need a formula in the cells of column A which finds matches of forename and surname in workbook 1 and copies “mem_no” from worksheet 1 to worksheet 2.
Each column of data represents column A, B C etc.
Single value matching with VLOOKUP I can cope with but not 2 columns.
Can someone help?
Worksheet 1 example
mkey | mem_no | status | title | forename | surname |
51355 | 857 | Current | Mr | Laurie | Adamson |
55701 | 1784 | Current | Mrs | Edel | Aguero |
51337 | 783 | Current | Mrs | Rosemary | Allen |
51472 | 1448 | Current | Mrs | Sylvia | Allen |
51453 | 1366 | Current | Mr | Greg | Ansell |
51454 | 1367 | Current | Mrs | Tiggy | Ansell |
51517 | 1574 | Current | Mrs | Pam | Applin |
51505 | 1546 | Current | Mrs | Ann | Arthur |
51566 | 1683 | Current | Mr | Ken | Ashman |
<tbody>
</tbody>
<tbody> </tbody> | | |
<tbody>
</tbody>