If formula with 3 condition

[triaji]

Hi all,

I have data input worksheet. The expected data are as follows:
1) If cell A is in the database then cell B will lookup to the database sheet
2) If in the cell A is not in the database, then the text "Please update database" is written
3) if cell A is empty then cell B is not N/A.

Please help, many thanks.

[AliGW]

Try this:

=IF(A3="","",IFNA(INDEX(Database!$B$3:$B$778,MATCH($A3,Database!$A$3:$A$778,0)),"Please update database"))

or:

=IF(A3="","",IFERROR(INDEX(Database!$B$3:$B$778,MATCH($A3,Database!$A$3:$A$778,0)),"Please update database"))

[triaji]

Dear Ms AliGW,

Thanks a lot for your answer. It works