Thread: Workbook matching

Hi everybody I am David from Spain. I work in an educational academy and have been put in charge of a task that is beyond my woefully limited excel skills!

Most of the work is done, but I need some help with the final part.

The (attached) speadsheet is to keep a record of students test results. There are 3 pages, the first (leveltest workbook) is unimportant as it is just for uploading users to our online platform. The second is the 'master' sheet where the office workers will be able to see the results. The third ('results') is imported from the online platform.

The Master sheet ALREADY imports the results and matches them to the correct user.


What I need is this:

I need the master sheet to look at the cells in columns G-N in the results sheet, and report back based on which cells are complete

For example if the cells in G,H,I and J have a value but L,M and N do not, I want it to display some text for J, as it is the highest complete (as in greater than 0) field. The text for every one would be a level (we use A1,A2,B1,B2,C1,C2,C2+ as our system of classifying our students).

David, you have posted the same question in a new thread. This is a duplicate post and as such does not comply with Rule 5 of our forum rules. Since your other thread has already received a reply, I'm closing this one.

Do not post the same question in more than one threads, please. Read the forum rules before you post any more.

thanks

Thread Closed.