Hi, you need to remove the bracket from after PD CODE" in order to make the
2nd if statement an else.
Jeff
"DCM84 " wrote in message
...
Hi, I kno this is not a programming query but im a beginner with MS
Excel and cant work out why this formula isnt workin! Here goes:
=IF(NOT(ISERROR(MATCH(A1,ValidData,0))),"IIBD ACC","INVALID CAUSE OR PD
CODE"),IF(NOT(ISERROR(MATCH(A1,ValidData2,0))),"II BD PD","invalid cause
code")
ValidData is cells H1:H4
ValidData2 is cells I1:I4
this is essentially two IF Statments combined so maybe ive done it
wrong?
Id be really really greatful if anyone can help
Thanx loads,
DCM84
---
Message posted from http://www.ExcelForum.com/