complicated IF function

[JMC57]

I am trying to have a value from sheet1 'Site Visit ASESSMENT for a specific cell to appear on another sheet (let's call it sheet 2) only if if certain statements exists in another cell such as E3 in sheet 1

Statemetns are PARTIAL COMPLIANCE,NOT COMPLIANT,NOT ASSESED,ADDITIONAL INFO NEEDED.

=IF(AND('Site Visit ASESSMENT)'!E3=PARTIAL COMPLIANCE,NOT COMPLIANT,NOT ASSESED,ADDITIONAL INFO NEEDED),'Site Visit ASESSMENT)'!A3)

I tried the above formua and it does not work. Any suggestions

 

[njimack]

=IF(OR('Site Visit ASESSMENT'!E3={"PARTIAL COMPLIANCE","NOT COMPLIANT","NOT ASSESED","ADDITIONAL INFO NEEDED"}),'Site Visit ASESSMENT'!A3,"")

 

[JMC57]

Tried it and it does not appear to work. I get a #Ref! error and a promt to save the document as Udated Values

 

[njimack]

It does work, check that you haven't mispelt the sheet name

Excel Workbook
	A
1	xxx
Sheet1

Excel Workbook
	A	B	C	D	E
1	*	*	*	*	*
2	*	*	*	*	*
3	xxx	*	*	*	NOT ASSESED
Site Visit ASESSMENT

 

[JMC57]

Thanks! and Sorry- I had a ) in the SS name Assessment) Took it out and it worked. Thanks again! Your help and follow up is greatly appreciated. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

 

[njimack]

You're welcome!