Nested ISBLANK

Hi guys,

I have the following formula which is currently working:

Please Login or Register  to view this content.

It's checking "Hold List.xlsx" using data entered in A2 and returning Hold if it matches or Cleared if not. I'm not sure if this is the best way to do it so suggestions on this would be appreciated.

I'm trying to add an IFBLANK statement so that if A2 is blank then it returns a blank in the formula column. If it isn't blank then it does the above formula. I'm just getting error after error though!

Thanks in advance!

Perfect! Thanks for the speedy response