I have membership data stored in a sheet and I need to extract data for some members to a second sheet.
Using vlookup I can extract the data without any problems. BUT, some members have 2 rows of data where the data is identical except the first row has a mobile phone number in column 8 and the second row has a home phone number in column 8.
How can I extract the home phone number from the second row and have it placed on the same row in the second sheet that I am extracting data to?
The second sheet will look like this:
Excel 2016 (Windows) 64 bit
<tbody>
</tbody>
A modded part of the Membership sheet showing a member with 2 rows of data (Home and Mobile phone):
Excel 2016 (Windows) 64 bit
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
TIA
Bob
Using vlookup I can extract the data without any problems. BUT, some members have 2 rows of data where the data is identical except the first row has a mobile phone number in column 8 and the second row has a home phone number in column 8.
How can I extract the home phone number from the second row and have it placed on the same row in the second sheet that I am extracting data to?
The second sheet will look like this:
Excel 2016 (Windows) 64 bit
A | B | C | D | E | F | |
---|---|---|---|---|---|---|
1 | Member# | Fname | Surname | Mobile # | Home Phone | |
2 | 2345 | Bill | Bloogs | bb@xxx.com | 0400123456 | 0312345678 |
<tbody>
</tbody>
Excel 2016 (Windows) 64 bit
B | C | D | E | F | G | H | I | J | K | L | |
---|---|---|---|---|---|---|---|---|---|---|---|
15 | 2345 | Bill | Bloogs | 123 First Street | Black Stump | VIC | 3551 | 312345678 | Home | bb@xxx.com | |
16 | 2345 | Bill | Bloogs | 123 First Street | Black Stump | VIC | 3551 | 400123456 | Mobile | bb@xx.com | |
17 | 3600 | KENNETH | xxxxxx | xxxxxxxxxxxxx | xxxxxx | xxxxxx | VIC | 3555 | 423234234 | Mobile | |
18 | 3601 | WAYNE | xxxxxx | xxxxxxxxxxxxx | xxxxxx | xxxxxx | VIC | 3555 | 434345345 | Mobile |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
TIA
Bob