Prepare automatic scoring sheet with pointing chart

On your contestant sheet move the Chest numbers to column A. Then on the score sheet in F4, type =VLOOKUP(E4,contestents!$A$4:$C$14,3,FALSE) and in G4 type =VLOOKUP(E4,contestents!$A$4:$C$14,2,FALSE) and then copy both cells down

dear alansidman

name and team names are coming
what about pointing ?

thanks to your help

You need to be more specific about your points. I have no clue as to what you want or how to do it. Please provide examples of what you want and how you would determine it logically. You have not provided enough information to give you a viable solution.

Hi

There no Name in it? That can't be done unless name set up in POINTS sheet!

So I work without name, only team, Item and points top 3 each item!

Set up Dummy in POINTS sheet highlight yellow

Score sheet

Column J to M

M4 Light Music Boys

Formula:

Please Login or Register  to view this content.

copy down row 6 hen change $J$4 to $J$7 and ROWS($M4:M7)) to ROWS ($M7:M7))for Light Music Girls. Do same with next Action Song Boys so on

L4 Light Music Boys

Formula:

Please Login or Register  to view this content.

This is array formula, Press same time Ctrl+Shift+Enter, NOT ENTER. Copy down row 6. Light Music Girls change $J$4 to $J$7 and COUNTIF(M$$:M7,M7))) to COUNTIF(M$7:M7,M7))) do same rest off different item!

See the file!

Regard