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 this is your duplicate post
http://www.excelforum.com/excel-form...wont-work.html
Punnam

Punnam,

thanks for your reply! I fixed it in the meantime.

regards