IF a cell contains a certain word then return the value from another cell

[broncos347]

I have a spreadsheet with columns A to K and a large number of rows.

In column K there are a number of words one of which is the word "Correct".

I have set up another spreadsheet to act as an import sheet to record the answers if the word "correct" is found in a cell in Column K. If the word is found I would like the value held in column H to be shown on the second sheet.

I have tried =IF(ISNUMBER(SEARCH('Sheet 1'!L2,'Sheet 2'!B15)),'Sheet 1'!B2) but this returns as FALSE and I'm struggling to find anything that would work for me.

Any help would be appreciated

Sheet 1

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	Overdue	Contract No.	Contract Title	Tenant	Ref	Description	Date Rqd	Software Date	Complete	Date Applied	Comment
2	Yes	907500	AUD REAR OF DOWN PLATFORM	???	907500 - RR001	907500 - Rent Review 001	25/03/2012	2012-03-25			Correct
Sheet 1

Sheet 2

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	Label	Contract.Code	Code	Description	User-defined status.System name	User-defined status.Business object	Action date	Action applied on	Contracting party	Action complete?	Comment
2		907005	907005 - RR001	907005 - Rent Review 001			2013-01-04		0086
Sheet 2

 

[sykes]

In cell you want the data to be pulled into, the "Second sheet":
=IF(Sheet1!K2="correct",Sheet1!H2,"")
should work.
You'll probably need to change the references etc.

 

[broncos347]

I didn't think it would be so simple, many thanks for your help.

 

[sykes]

Pleasure, and thanks for the feedback.