Lookup and sort issue
 

Hi chaps,
Im struggling to get this working if anyone could help please €“ heres a
simplified version of what Im trying to achieve:

A B C D E F G H
I J
1 Job Nº Date Name Address Mark1 Mark2 Mark3 Total
2 1 5/7/09 Fred London 3 2 8
3 2 5/7/09 Bill Norwich 2 6 4
4 3 8/7/09 Matt Bristol 4 1 1
5 4 8/7/09 Jack Cardiff 5 5 7
6 5 9/7/09 Eric Poole 1 5 6
7
8
9
10
11
12
13
14
15 2 5/7/09 Bill Norwich Various calcs here
29
16
17 5 9/7/09 Eric Poole Various calcs here
15
18 1 5/7/09 Fred London Various calcs here
11
19 4 8/7/09 Jack Cardiff Various calcs here
31
20
21 3 8/7/09 Matt Bristol Various calcs here
10

Basic data is entered in cells A2:G6.
This basic data is then pulled directly down the spreadsheet (A15:G21) where
various calculations are performed. Each line of data stays together although
the line order gets mixed up (no longer in Job Nº order), and also some gaps
appear between the various lines of calculated data.
Eventually a Total figure is calculated and appears in cells J15:J21.

I simply need to get the Total figures back up the spreadsheet from J15:J21
into J2:J5, with each Total alongside the relevant Job Nº at the top of the
spreadsheet.

Many thanks.
Steve.

Lookup and sort issue
 

Some form of VLOOKUP should work. perhaps:

=VLOOKUP(A2,$A$15:$J$21,10,FALSE)

You could place this into row 2 somewhere, and then copy down.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Struggling in Sheffield" wrote:

Hi chaps,
Im struggling to get this working if anyone could help please €“ heres a
simplified version of what Im trying to achieve:

A B C D E F G H
I J
1 Job Nº Date Name Address Mark1 Mark2 Mark3 Total
2 1 5/7/09 Fred London 3 2 8
3 2 5/7/09 Bill Norwich 2 6 4
4 3 8/7/09 Matt Bristol 4 1 1
5 4 8/7/09 Jack Cardiff 5 5 7
6 5 9/7/09 Eric Poole 1 5 6
7
8
9
10
11
12
13
14
15 2 5/7/09 Bill Norwich Various calcs here
29
16
17 5 9/7/09 Eric Poole Various calcs here
15
18 1 5/7/09 Fred London Various calcs here
11
19 4 8/7/09 Jack Cardiff Various calcs here
31
20
21 3 8/7/09 Matt Bristol Various calcs here
10

Basic data is entered in cells A2:G6.
This basic data is then pulled directly down the spreadsheet (A15:G21) where
various calculations are performed. Each line of data stays together although
the line order gets mixed up (no longer in Job Nº order), and also some gaps
appear between the various lines of calculated data.
Eventually a Total figure is calculated and appears in cells J15:J21.

I simply need to get the Total figures back up the spreadsheet from J15:J21
into J2:J5, with each Total alongside the relevant Job Nº at the top of the
spreadsheet.

Many thanks.
Steve.

Lookup and sort issue
 

Thanks very much Luke, that's simple and effective and will save me an awful
lot of pratting about. As usual I nearly managed it myself earlier (but as
usual my version had the odd flaw!).
Cheers, have a good weekend,
Steve.

"Luke M" wrote:

Some form of VLOOKUP should work. perhaps:

=VLOOKUP(A2,$A$15:$J$21,10,FALSE)

You could place this into row 2 somewhere, and then copy down.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Struggling in Sheffield" wrote:

Hi chaps,
Im struggling to get this working if anyone could help please €“ heres a
simplified version of what Im trying to achieve:

A B C D E F G H
I J
1 Job Nº Date Name Address Mark1 Mark2 Mark3 Total
2 1 5/7/09 Fred London 3 2 8
3 2 5/7/09 Bill Norwich 2 6 4
4 3 8/7/09 Matt Bristol 4 1 1
5 4 8/7/09 Jack Cardiff 5 5 7
6 5 9/7/09 Eric Poole 1 5 6
7
8
9
10
11
12
13
14
15 2 5/7/09 Bill Norwich Various calcs here
29
16
17 5 9/7/09 Eric Poole Various calcs here
15
18 1 5/7/09 Fred London Various calcs here
11
19 4 8/7/09 Jack Cardiff Various calcs here
31
20
21 3 8/7/09 Matt Bristol Various calcs here
10

Basic data is entered in cells A2:G6.
This basic data is then pulled directly down the spreadsheet (A15:G21) where
various calculations are performed. Each line of data stays together although
the line order gets mixed up (no longer in Job Nº order), and also some gaps
appear between the various lines of calculated data.
Eventually a Total figure is calculated and appears in cells J15:J21.

I simply need to get the Total figures back up the spreadsheet from J15:J21
into J2:J5, with each Total alongside the relevant Job Nº at the top of the
spreadsheet.

Many thanks.
Steve.