If then formula

[Monnie95]

Hi,

I have a spreadsheet which on the first worksheet shows a range of data with the first column being name of a person.

The second worksheet is a breakdown of information for that person only.

What I want the formula to do is:

If Worksheet A, Column A1 says JOE BLOGGS, then copy the whole row to next worksheet.

Does that make sense?

Does anyone have the IF THEN formula to copy row to another spreadsheet if it contains certain information from one cell?

[dredwolf]

Without being able to see the data, its pretty hard to offer a precise answer, but maybe something like this (I'm going to use default sheet names here):
Sheet1 data is in A1:E100
Sheet2 A1 = Joe Bloggs
in Sheet2 A2:
=INDEX(Sheet1!$A$1:$E$100,MATCH($A$1,Sheet1!$A$1:$A$100,0),COLUMN())
Drag across to column E
or
=VLOOKUP($A$1,Sheet1!$A$1:$E$100,COLUMN(),0)
Drag across to column E

Hope this helps