Hello, I am trying to do a look up, to look at a cell I have entered a row
number in from a previous sheet. That row number relates to a certain entry
of about 4 columns. I would like to have 4 cells do the look up to relate to
a particular entry for the row I have entered in the cell above. I hope this
makes sense.

In other words I have entered a company, contact etc in one sheet. I
another sheet I have a form which I would like to have the details from say
row 10 entered into. In another cell e.g. A9 I would like to enter row 10
into, which will then populate my form.

Is there any way this can be done, really appreciate any help!!!

Hi,

What you should use in INDIRECT

Suppose the data is in the range A1:D100 on Sheet1 and you want to enter the
row number in cell A1 of Sheet2 and have A2:D2 of Sheet2 show the appropriate
results, then:

In cell A2 of Sheet2 enter the formula:

=INDIRECT("Sheet1!A" &$A$1 & ":D" & $A$1)

then copy the formula to the right to column D.

--
Cheers,
Shane Devenshire


"Chris O" wrote:

Hello, I am trying to do a look up, to look at a cell I have entered a row
number in from a previous sheet. That row number relates to a certain entry
of about 4 columns. I would like to have 4 cells do the look up to relate to
a particular entry for the row I have entered in the cell above. I hope this
makes sense.

In other words I have entered a company, contact etc in one sheet. I
another sheet I have a form which I would like to have the details from say
row 10 entered into. In another cell e.g. A9 I would like to enter row 10
into, which will then populate my form.

Is there any way this can be done, really appreciate any help!!!