Hi

Following is my issue:

I have 1 column of data and I have named the range
$A$2:$A$30 as Data_1.

I have following data in it (sample)

854000A13A0099002
854000A13AV031004

When I put the following formula in A1
=IF(Data_10,"yes","")

it gives me #VALUE as result but when I put it anywhere infront of Row
2 to Row 30 it works (any column).

I am sure I am missing something very small but I cant figure it out.

If someone could please tell me what may be the reason.

Thanks,
Naeem