Hi, I kno this is not a programming query but im a beginner with M
Excel and cant work out why this formula isnt workin! Here goes:

=IF(NOT(ISERROR(MATCH(A1,ValidData,0))),"IIBD ACC","INVALID CAUSE OR P
CODE"),IF(NOT(ISERROR(MATCH(A1,ValidData2,0))),"II BD PD","invalid caus
code")

ValidData is cells H1:H4
ValidData2 is cells I1:I4

this is essentially two IF Statments combined so maybe ive done i
wrong?

Id be really really greatful if anyone can help

Thanx loads,
DCM8

--
Message posted from http://www.ExcelForum.com