Plug-in scores to a results sheet

**mjhaston** · 09-30-2009, 04:20 PM

I have two spreadsheets. One is a listing of football scores from the previous week. The other is the schedule for that week. I would like to be able to populate one from the other.

Even if someone could point me in the direction of which functions to use that would be helpful.

Based on the data in the results spreadsheet in columns M, N and P ... I need to look in the scores spreadsheet and compare to columns A, F, H and I. I would need to retrieve columns G and J for their scores.

I've been looking at SEARCH, LEFT AND VLOOKUP so far!

Thanks in advance.

**zbor** · 09-30-2009, 04:22 PM

Can you upload example workbook with dummy data?

**mjhaston** · 09-30-2009, 05:30 PM

Sure can. I'm trying to populate the results tab with the weekly scores data.

**DonkeyOte** · 10-01-2009, 03:19 AM

I've just had a quick look at this and I confess I can't entirely fathom what's happening... for ex. if we filter the weekly_scores sheet such that we're looking only at QK as home side (Col A) and then try and tie that back to the AT: QK section on the results...

It would "appear" that the number suffix post side (eg QK1, QK4) should match the number suffix post # sign on weekly scores sheet (Cols F & I), correct ?

However, if you look at the results summary for AT: QK and compare to weekly_scores data we find the sides don't actually tie out.

For ex. in row 21 you have a result between QK2 and LA2 ... LA are not listed as away assoc on your scores sheet ?

I would in fact have expected this line:

FL-N	QK2	27	LA2	12

to read

FL-N	QK1	27	PA1	12

given the flag number is #1 for both sides and the opponent is seemingly PA not LA.

Can you provide any further insights as to how this works ?
(ie am I right and this is an error in your results sheet or am I misreading how this is meant to work ?)

**mjhaston** · 10-01-2009, 08:30 AM

Since I code the PHP application that is capturing this data I can make sure the naming convention is identical in both spreadsheets. This was all done manually in the past and now I'm trying to automate as much as possible.

**DonkeyOte** · 10-01-2009, 08:41 AM

OK... but that doesn't really answer my question.

Let's change tack... and look at row 29 on results sheet
(with row 28 being AT: PD)

M29: 80-N
N29: PD1
P29: NS1

Having looked at the data that is listed on results sheet thus far I interpret the requirements in terms of matching to weekly_scores as being:

Column A = PD (@ PD)
Column D = 5 (week 5)
Column F = 80 #1 ... 80 from M29 plus # from N29 (where FL-N becomes Flag # etc...)
Column H = NS (remove the # from string in P29)
Column I = 80 #1 ... 80 from M29 plus # from P29 (where FL-N becomes Flag # etc..)

So where we find

PD	xx	xx	5	27/09/2009	80 #1	19	NS	80 #1	0

we retrieve scores from columns G & J respectively (Home & Away)

Is the above all correct ?

The above is all based on my interpretation of your existing results. In your posts you fail to explain the relationship between these values and thus given the vague nature of the data and narrative most will have looked at this attachment and left it given it's not clear how you're getting the results. This is made all the worse if there are results that do not appear to tie out to source data as highlighted in my prior post.