On Sun, 12 Mar 2006 10:18:55 GMT, "outwest" <u19594@uwe wrote:

Hi Paul,
yes, sorting the data across the columns is easy enuff.
But lets say truck 1 is in A1, then I would go for =VLOOKUP(A1,Sheet2!$A$1:$F
$200,1,0),B1
=VLOOKUP(A1,Sheet2!$A$1:$F$200,2,0),C1 etc.
but the truck in A2 or A286 will have a different combination of data, so I
would need to do =VLOOKUP(A2,Sheet2!$A$1:$F$200,1,0),B1
=VLOOKUP(A2,Sheet2!$A$1:$F$200,2,0),C1 etc. then A3, A4 all the way down to
A286.
I was hoping there was a way to increase the A1, A2 part of the formula
automatically as I entered each new line (row).
Hence I was hoping to click on column B(whatevernumber) and have it look
across at column A(whatevernumber) then go to sheet 2 to piece together the
relevant data.

=VLOOKUP(A1,Sheet2!$A$1:$F$200,1,0), works fine, its just kinda seems a bit
pre-computerised to have to change it for every row.

Its all hard to explain sorta :-) but Im trying my best.


I'm obviously still not quite understanding your problem.
with B1=
=VLOOKUP(A1,Sheet2!$A$1:$F$200,1,0)
when you copy this down to B2, surely you end up with
=VLOOKUP(A2,Sheet2!$A$1:$F$200,1,0)

What do you mean when you say above 'as I enter each new line (row)'?
Are you not just entering a new value in A2 and copying B1 to B2?

Rgds


paul wrote:
i dont quite understand the problem.All you have to do is write the first row
of formula changing the column numbers as you go across,then copy the columns
down the rest of the rows required .
so a1 is=VLOOKUP(A1,Sheet2!$A$1:$F$200,1,0),B1
is=VLOOKUP(A1,Sheet2!$A$1:$F$200,2,0),C1
is=VLOOKUP(A1,Sheet2!$A$1:$F$200,3,0),and so on then copy down.....

The data I want will be text, such as column B=colour, column C=weight etc

[quoted text clipped - 8 lines]

Thanks for such a speedy response.

Richard Buttrey
__