Lookup and sort issue

  • Thread starter Struggling in Sheffield
  • Start date
S

Struggling in Sheffield

Hi chaps,
I’m struggling to get this working if anyone could help please – here’s a
simplified version of what I’m 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.
 
L

Luke M

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.
 
S

Struggling in Sheffield

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top