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!!!