Looking up values

[ranjan20]

Dear Experts,

Need to populate Summary sheet of the attached same sample workbook with their(for each team) corresponding score recorded against each date on Scoring sheet.

Was trying to achieve this with Hlookup and using locking cells but results are not properly captured.

Looking for help if their could be any better way of doing this please. thanks

[Glenn Kennedy]

How is this a summary? One sheet is an exact copy of the other. Or am I missing something?

=IFERROR(1/(1/Scoring!B2),"")

copied across and down.

If not, remove your formula and add expected answers...

[ranjan20]

Thanks Glen, can see its working!

My bad with data values for scoring sheet tagged against each date for each which could be alphanumeric as well like if we see in latest attached template.
Looks like with an alphanumeric values its not giving those values on summary sheet.

And yes you correctly mentioned both sheet are same but idea is the summary sheet would be built further by taking scores from scoring sheet.
Hope able to explain..thanks

[windknife]

B2
=IF(Scoring!B2="","",Scoring!B2)

[ranjan20]

Thanks its working alright.

[Glenn Kennedy]

Post #4 will do that, but TBH, why?? Why make an exact copy of the original table???

If this still isn't what you want, you need to SHOW us what you are REALLY working with and REALLY trying to do.

[ranjan20]

Apologies Glen, working to build a team capacity planning on summary sheet where teams leave's having mixed on data on scoring sheet some one inserted 1 and other Full day as F and Half Day as H so alphanumeric.
My bad as initially all data values on scoring tab not provided in sample.

[Glenn Kennedy]

OK! You're welcome.

[windknife]

You are welcome.

--------------------------------------
If that takes care of your original question, please click on "Thread Tools" from the menu link above and mark this thread as SOLVED.