I have two Excel worksheets in the same file.
One is a full list of Parents and their associated children.
The other is a list of Parents and their platform logins.
For some reason, I have a discrepancy in length between the two files - i.e. there is 570 users in one file and 599 in the other.
What I'd like to do is - presumably using
VLOOKUP - display the parents' passwords if their usernames match on both sheets.
Sheet one (called ParentChildren)
Sheet two (called ParentLogins)
What I'd like to do...
ParentUsername in !ParentChildren matches
Username in !ParentLogins, fill the
Password field on !ParentChildren (which is currently empty) with the data from the corresponding
Password field on !ParentLogins.
If a row doesn't match - i.e. there's a username which exists in !ParentChildren but not !ParentLogins, I'd like that row's
Password field in !ParentChildren to remain empty.
Hope that makes sense - think I've somewhat confused myself!
Thanks in advance,