If(Iserror... Question

[isadoko]

I am trying to get this formula to work but cannot understand my error. I would appreciate any help. It was fine until I add the search for Customer. Thanks.

IF(ISERROR(D28="Customer","Customer",(VLOOKUP(O28,CRISMSTR!$B$392:$R$7572,14,FALSE))),"No Data",(D28="Customer","Customer",(VLOOKUP(O28,HRISMSTR!$B$392:$R$7572,14,FALSE)))

 

[Special-K99]

Can you explain in words what you're trying to achieve?

 

[isadoko]

I want the formula to look for the term "Customer" and display it if there, else lookup the code or identifier in the field here, CRISMSTR!$B$392:$R$7572,14, if one is there, otherwise simply tell me that the field is empty and thus No Data. Help?

 

[Special-K99]

Try (untested)

=IF(D28="Customer","Customer",IF(ISERROR(VLOOKUP(O28,CRISMSTR!$B$392:$R$7572,14,FALSE)),ISERROR(VLOOKUP(O28,HRISMSTR!$B$392:$R$7572,14,FALSE)),"No Data"))