Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy formulas but using the same range each time I copy | Excel Worksheet Functions | |||
lookup field and copy the row across | Excel Worksheet Functions | |||
Lookup in a range. | Excel Discussion (Misc queries) | |||
Range Lookup | Excel Discussion (Misc queries) | |||
lookup and copy | Excel Worksheet Functions |