Log In
Register
Home
Find multiple values on another sheet
Diogo Tomás
New Member
Members
Forum Posts: 1
Member Since:
November 27, 2020
November 27, 2020
Offline1
November 27, 2020 - 9:47 pm
Hi, I have 1 file with 2 sheets. On the Employee Sheet, I have the employee number. On the other sheet, I have the various places where the employee works. I wanted to cross the 2 sheets. I'll show you an example.
Thanks
Purfleet
England
Member
Members
Trusted Members
Trusted Members
Forum Posts: 412
Member Since:
December 20, 2019
December 20, 2019
Offline2
November 28, 2020 - 12:30 pm
Please upload example workbook rather than pictures
jab che
Member
Members
Forum Posts: 16
Member Since:
June 25, 2020
June 25, 2020
Offline3
November 29, 2020 - 8:03 pm
Hi Diogo,
Not quite sure what you're trying to achieve here
From your description on Sheet-1 it sounds like all you're going to do is replicate Sheet-2
Perhaps if you could supply an example of what you'd like to see?
In a workbook?
jim
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Lawrence Smith
Guest(s) 10
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 870
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Ivica Cvetkovski
Blaine Cox
Shankar Srinivasan
riyepa fdgf
Hannah Cave
Len Matthews
Kristine Arthy
Michelle Neven
Andrew Kuhn
Angela Paul
Forum Stats:
Groups: 3
Forums: 24
Topics: 6206
Posts: 27202
Member Stats:
Guest Posters: 49
Members: 31875
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —