ERROR ALERT on INDIRECT formula won't work

Hi everybody,

I'm having an issue with the error alert in a data validation list, that won't pop up.
The formula I'm using for list source is:
=IF($F6="";INDIRECT($G6);INDIRECT($F6))

Any suggestions are highly appreciated!

Regards

hi,

Upload a sample workbook with out any confidential data .

Punnam