Lookup & copy range
 

Hello
I need to copy a set of data for users which is organised into approx 20col
x 2 rows
As below
Number Cost Cost1 Cost2 etc
David 1 £5 10 15
5 £6 12 18
Peter 3 £3 56 56
5 £5 55 40
Paul 6 £6 56 65
8 £6 64 75

I want to look up a name & update the data
Number Cost Cost1 Cost2 etc
David 1 £5 10 15
5 £6 12 18
Any ideas welcome.

Lookup & copy range
 

If original data is on Sheer1, then with name in A2 on Sheet2:

in B2:

=INDEX(Sheet1!B:B,MATCH($A$2,Sheet1!$A:$A,0))

and copy across

in B3:

=INDEX(Sheet1!B:B,MATCH($A$2,Sheet1!$A:$A,0)+1)

and copy across

Does this help?

"Saintsman" wrote:

Hello
I need to copy a set of data for users which is organised into approx 20col
x 2 rows
As below
Number Cost Cost1 Cost2 etc
David 1 £5 10 15
5 £6 12 18
Peter 3 £3 56 56
5 £5 55 40
Paul 6 £6 56 65
8 £6 64 75

I want to look up a name & update the data
Number Cost Cost1 Cost2 etc
David 1 £5 10 15
5 £6 12 18
Any ideas welcome.

Lookup & copy range
 

Thanks very much for both speed of reply & a good answer

Saintsman

"Toppers" wrote:

If original data is on Sheer1, then with name in A2 on Sheet2:

in B2:

=INDEX(Sheet1!B:B,MATCH($A$2,Sheet1!$A:$A,0))

and copy across

in B3:

=INDEX(Sheet1!B:B,MATCH($A$2,Sheet1!$A:$A,0)+1)

and copy across

Does this help?

"Saintsman" wrote:

Hello
I need to copy a set of data for users which is organised into approx 20col
x 2 rows
As below
Number Cost Cost1 Cost2 etc
David 1 £5 10 15
5 £6 12 18
Peter 3 £3 56 56
5 £5 55 40
Paul 6 £6 56 65
8 £6 64 75

I want to look up a name & update the data
Number Cost Cost1 Cost2 etc
David 1 £5 10 15
5 £6 12 18
Any ideas welcome.

Lookup & copy range
 

Thank you for the feedback.

"Saintsman" wrote:

Thanks very much for both speed of reply & a good answer

Saintsman

"Toppers" wrote:

If original data is on Sheer1, then with name in A2 on Sheet2:

in B2:

=INDEX(Sheet1!B:B,MATCH($A$2,Sheet1!$A:$A,0))

and copy across

in B3:

=INDEX(Sheet1!B:B,MATCH($A$2,Sheet1!$A:$A,0)+1)

and copy across

Does this help?

"Saintsman" wrote:

Hello
I need to copy a set of data for users which is organised into approx 20col
x 2 rows
As below
Number Cost Cost1 Cost2 etc
David 1 £5 10 15
5 £6 12 18
Peter 3 £3 56 56
5 £5 55 40
Paul 6 £6 56 65
8 £6 64 75

I want to look up a name & update the data
Number Cost Cost1 Cost2 etc
David 1 £5 10 15
5 £6 12 18
Any ideas welcome.