Excel Lookup and Return
Budget: £10 – £20 GBP
I am looking for a freelancer who can assist with an Excel lookup and return project.
On the file attached is a comments master sheet. Days 1-7 i will populate daily but i would like to return any names i populate in sheets day-day7 check against column E in comments master sheet and if it matches the return on the day sheet them time elapsed from column A on comments sheet to present day then also the course and the comment for the matched name. I have edited my file with an example at the top of what is required.
Data Type:
- The data that needs to be looked up and returned is in the form of text.
Matching Type:
- The lookup function should match exact values only.
Dataset Size:
- Unfortunately, the client did not answer this question, so we do not have information about the size of the dataset.
Skills and Experience:
- Proficiency in Excel and advanced knowledge of lookup functions.
- Experience working with large datasets would be beneficial if the dataset turns out to be large.
- Attention to detail to ensure accurate lookup and return of data.
On the file attached is a comments master sheet. Days 1-7 i will populate daily but i would like to return any names i populate in sheets day-day7 check against column E in comments master sheet and if it matches the return on the day sheet them time elapsed from column A on comments sheet to present day then also the course and the comment for the matched name. I have edited my file with an example at the top of what is required.
Data Type:
- The data that needs to be looked up and returned is in the form of text.
Matching Type:
- The lookup function should match exact values only.
Dataset Size:
- Unfortunately, the client did not answer this question, so we do not have information about the size of the dataset.
Skills and Experience:
- Proficiency in Excel and advanced knowledge of lookup functions.
- Experience working with large datasets would be beneficial if the dataset turns out to be large.
- Attention to detail to ensure accurate lookup and return of data.