Hi,
i am new to Excel and need to make some way to match mentors and mentees. Currently there are only about 100 but it will increase. We don't have data of the mentees, just the mentors so what I would I deally like is that mentees can fill in a short form and excel spews out a list of 5 possible matches that they can then look up in our catalogue (as previously they have had to trawl through the whole lot to find a mentor). I expect that mentees would like to find a mentor by specialist topic area, clinical qualification, location and perhaps gender. I am attaching the dtaa I have inherited and currently staff can look up lists of peoples names on the first sheet by topic then look for their contact details on the second sheet. I am just hoping to make this a little easier.
As a complete beginner I would like pointers as to where to start. What tutorials I should be watching/ reading and what i should be searching.
I have attached the file but removed the names etc.
Many thanks.![]()
Bookmarks