Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Bengaluru, IN

Welcome to the Bengaluru User Group

Click in the JOIN GROUP button in Home to follow our news and attend our events!

Excel vlookup, How to do vlookup output manipulation?

MahanteshS
8 - Asteroid

Excel File 1: UserId, RoleName

Excel File 2: UserId, RoleName

 

after doing vlook up i want only "RoleName" of 1st excel file. how to get it?

 

as of now i am getting for both rolenames.

1 REPLY 1
MarqueeCrew
20 - Arcturus
20 - Arcturus
You can uncheck the second role name field coming from the right input. There is also an OPTION to uncheck duplicate fields.

Cheers,
Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.