Formula help

[TonyB1]

Hi, this is prob really simple so apologies.
I am trying to set up an appraisal form with A to E grading. I have added a list to select A* or B* etc to act as the selected score. I am trying to pull the selected Value in that range to a master tab so I can see grades across the sections. Hope that makes sense.

 

[myall_blues]

Hope that makes sense.

Not really no.
Perhaps you could post a subset of data of your setup and master with desired result, preferably with XL2BB if you can.

 

[TonyB1]

Ahh ok, I’ll post a subset of the file

 

[TonyB1]

Ok struggling to upload a sample sheet so will try and explain.
I have a tab where I input staff markings, each cell contains a letter A to E. to select a mark there is a dropdown so I can select say B*. I want to display that mark in a summary tab. So looking for a formula that takes the B* from a row of A B* C D E.

 

[myall_blues]

Even a picture would help as we're still not much wiser. Without some idea how things are arranged we can't help you.
Perhaps a few questions to clarify things. I will call the respective tabs 'Input' for where you input the staff marks and 'Summary' for the summary tab.

• Presumably there are names involved on both sheets, so assuming you want to match marks with names between the two sheets?
• Are there dates along the top or something similar that need to be matched? i.e. for each staff member are there multiple marks to transfer by date?
• Are the names and marks arranged by columns or rows? Which is which.
• When you say B*, is that literal or are you just using * as a device to show which one is selected.

I hope you can see that at face value from the statement "I have a tab where I input staff markings, each cell contains a letter A to E" it's not really clear why you need a summary at all.