Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP! Please!
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 |