Greetings everyone!
I have an excel file with 2 spreadsheets in it that house my data:
Tab 1: Raw Data, along with a separate Column for my VLOOKUP
Tab 2: Data, Tab 1 pulls from for the vlookup.
What i would like to do is the following: (Use the IF statement)
I would like another column B on tab 1 to return data from tab 2, but only on the results from the vlookup Column A.
Tab 2 is a sheet of usernames and email addresses in 2 separate columns
Tab 1 is a raw data sheet with a bunch of info on it. my vlookup on tab 1 column A only returns results on matched usernames from tab 2.
I would like to have tab 1 display the email address from tab 2 if the username is matched in my vlookup.
Bookmarks