Copying certain ceels in 1 sheet to another sheet in different locations

[Khalil Handal]

Hi,

Sheet1 contains a list of names with and information about each name in the
same line that is numbered from 1 to 45. The first name is in cell B14 (A14
is for its number which is 1).

I have also sheet2. In this sheet I want to obtain information from sheet1
from some of the cells and put them in different locations in sheet2.

To make it more clear:
Sheet1 Sheet2
B14 to B7
D14 to B8
E14 & F14 & G14 To B9
H14 to E14
Average of I14, J14 to F14
Average of O14, P14 to F15
T14 to E14
Average of U14, V14 to F16
BW14 to F17
and so on for few more cells.

In order to select which person from sheet1, I want to put a number in cell
B2 in sheet2 and the program will select that person's number.
ie. if I put 3 in cell B2 (and pressed enter) I want the cells to be taken
from sheet1 for that person who has number 3.

A friend mentioned that I can do this with LOOKUP or VLOOKUP !. I dont have
an idea abot how this can be done!

Can anyone help please?

Khalil

 

[E-Coder]

I placed this formula in cell B7 on Sheet 2.

=VLOOKUP(B1,Sheet1!A14:B58,2)

 

[E-Coder]

Hi,

Sheet1 contains a list of names with and information about each name in the
same line that is numbered from 1 to 45. The first name is in cell B14 (A14
is for its number which is 1).

I have also sheet2. In this sheet I want to obtain information from sheet1
from some of the cells and put them in different locations in sheet2.

To make it more clear:
Sheet1 Sheet2
B14 to B7
D14 to B8
E14 & F14 & G14 To B9
H14 to E14
Average of I14, J14 to F14
Average of O14, P14 to F15
T14 to E14
Average of U14, V14 to F16
BW14 to F17
and so on for few more cells.

In order to select which person from sheet1, I want to put a number in cell
B2 in sheet2 and the program will select that person's number.
ie. if I put 3 in cell B2 (and pressed enter) I want the cells to be taken
from sheet1 for that person who has number 3.

A friend mentioned that I can do this with LOOKUP or VLOOKUP !. I dont have
an idea abot how this can be done!

Can anyone help please?

Khalil

 

[Khalil Handal]

Hi,
What about the cells containing the average?
Any ideas?

Khalil

 

[E-Coder]

Excel is only going to return the value in the cell in a lookup formula. You
can add another column to calculate the averages. And if it's not relevant
data that needs to be seen, just hide the column. Then You can include that
hidden column in your formula and return Averaged values as needed.

Eric

 

[Khalil Handal]

Thanks,
I will try it.

Excel is only going to return the value in the cell in a lookup formula.
You
can add another column to calculate the averages. And if it's not relevant
data that needs to be seen, just hide the column. Then You can include
that
hidden column in your formula and return Averaged values as needed.

Eric