You're welcome. Thanks for the feedback!

Biff

"natei6" <natei6.1yz21n_1132786501.4045@excelforum-nospam.com> wrote in
message news:natei6.1yz21n_1132786501.4045@excelforum-nospam.com...
>
> Biff Wrote:
>> Hi!
>>
>> What's the other formula look like?
>>
>> > =IF($C$1="Glamour","15.688",IF($C$1="Econo","15.563","Select
>> Style"))
>>
>> Try removing the quotes from around the numbers:
>>
>> =IF($C$1="Glamour",15.688,IF($C$1="Econo",15.563,"Select Style"))
>>
>> Biff
>>
>> "natei6" <natei6.1yysjy_1132774201.5328@excelforum-nospam.com> wrote
>> in
>> message news:natei6.1yysjy_1132774201.5328@excelforum-nospam.com...
>> >
>> > Hi All,
>> >
>> > I have a range of cells and some of them contain this formula:
>> > =IF($C$1="Glamour","15.688",IF($C$1="Econo","15.563","Select
>> Style")).
>> > The problem I have is when I query this range on another work sheet,
>> it
>> > leaves the results of any cells with this formula blank. It is
>> > important to me to have this formula in the cell, do you have any
>> > suggestions.
>> >
>> > Sincerely,
>> >
>> > Nathan Sargeant
>> >
>> >
>> > --
>> > natei6
>> >
>> ------------------------------------------------------------------------
>> > natei6's Profile:
>> > http://www.excelforum.com/member.php...fo&userid=7185
>> > View this thread:
>> http://www.excelforum.com/showthread...hreadid=487745
>> >
> Thank you so much for the quick response Biff. You are the Man!
> Nathan Sargeant
>
>
> --
> natei6
> ------------------------------------------------------------------------
> natei6's Profile:
> http://www.excelforum.com/member.php...fo&userid=7185
> View this thread: http://www.excelforum.com/showthread...hreadid=487745
>