If statement

If in a range of cells there is any blank cell, it should return the value
in a particular cell.

For Eg

A B C D E F G
Xyz Local 1.59 1.46 0.75 1.29

If in the range A1:G1 there is a blank cell, then it should return A1. Ie it
should return Xyz.

Any help is appreciated.

Thanks
Rajula