This may be bit complicated to explain as can't use the work in question as its to do with my job.
Here is my problem.
Two spreadsheets -
1 - Gathering sheet (Column B - Username, C - E-mail- D - Name)
2 - Database sheet (Contains Usernames B, E-mails C, Address etc D, Name - E Look up spreadsheet)
On the Gathering sheet I have 4 columns B-D. Currently how my sheet works if I enter a persons username in B2 this then will populate C-D details by using look up (Database sheet). If username is unknown but e-mail is known I can enter the email in Column C which then populates B&D (circular reference). For me this works fine but want I want to do is create a extra column (Column A) where they can enter either username/e-mail and then that will populate B-D columns then "Not found" if no data is not found. Is this possible?.
I use a combination of Vlookup and Xlookup currently. I am thinking it may require multiple IF functions.
Any help will be great.
Here is my problem.
Two spreadsheets -
1 - Gathering sheet (Column B - Username, C - E-mail- D - Name)
2 - Database sheet (Contains Usernames B, E-mails C, Address etc D, Name - E Look up spreadsheet)
On the Gathering sheet I have 4 columns B-D. Currently how my sheet works if I enter a persons username in B2 this then will populate C-D details by using look up (Database sheet). If username is unknown but e-mail is known I can enter the email in Column C which then populates B&D (circular reference). For me this works fine but want I want to do is create a extra column (Column A) where they can enter either username/e-mail and then that will populate B-D columns then "Not found" if no data is not found. Is this possible?.
I use a combination of Vlookup and Xlookup currently. I am thinking it may require multiple IF functions.
Any help will be great.