Prev: Standard deviation and bell curve
Next: Need function to return numbers at beginning of text
From: Jan Ogg on 15 Apr 2010 15:45
I have a VLOOKUP on one worksheet =VLOOKUP(A1,'Tasks'!A1:C17,2,FALSE) which
refers to looking up the 2nd column of the reference A1 on the sheet that the
formula resides, but it only returns the formula not the requested
information. My other columns work fine. The cell that A1 refers to is a
drop down list but in the template it is as well. Any help?
From: T. Valko on 15 Apr 2010 17:33
Sounds like the cell is formatted as TEXT.

Change the cell format to General. Then, with the cell still selected hit
function key F2 then hit Enter.

--
Biff
Microsoft Excel MVP


"Jan Ogg" <JanOgg(a)discussions.microsoft.com> wrote in message
news:9CE4F515-B862-4EF8-A891-C45B70652FB7(a)microsoft.com...
>I have a VLOOKUP on one worksheet =VLOOKUP(A1,'Tasks'!A1:C17,2,FALSE) which
> refers to looking up the 2nd column of the reference A1 on the sheet that
> the
> formula resides, but it only returns the formula not the requested
> information. My other columns work fine. The cell that A1 refers to is a
> drop down list but in the template it is as well. Any help?


From: Jan Ogg on 15 Apr 2010 19:12
That did it! Thank you so much.
Jan

"T. Valko" wrote:

> Sounds like the cell is formatted as TEXT.
>
> Change the cell format to General. Then, with the cell still selected hit
> function key F2 then hit Enter.
>
> --
> Biff
> Microsoft Excel MVP
>
>
> "Jan Ogg" <JanOgg(a)discussions.microsoft.com> wrote in message
> news:9CE4F515-B862-4EF8-A891-C45B70652FB7(a)microsoft.com...
> >I have a VLOOKUP on one worksheet =VLOOKUP(A1,'Tasks'!A1:C17,2,FALSE) which
> > refers to looking up the 2nd column of the reference A1 on the sheet that
> > the
> > formula resides, but it only returns the formula not the requested
> > information. My other columns work fine. The cell that A1 refers to is a
> > drop down list but in the template it is as well. Any help?
>
>
> .
>
From: T. Valko on 15 Apr 2010 21:12
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Jan Ogg" <JanOgg(a)discussions.microsoft.com> wrote in message
news:A2D1888D-4988-4C48-9172-DBC5B632FB1F(a)microsoft.com...
> That did it! Thank you so much.
> Jan
>
> "T. Valko" wrote:
>
>> Sounds like the cell is formatted as TEXT.
>>
>> Change the cell format to General. Then, with the cell still selected hit
>> function key F2 then hit Enter.
>>
>> --
>> Biff
>> Microsoft Excel MVP
>>
>>
>> "Jan Ogg" <JanOgg(a)discussions.microsoft.com> wrote in message
>> news:9CE4F515-B862-4EF8-A891-C45B70652FB7(a)microsoft.com...
>> >I have a VLOOKUP on one worksheet =VLOOKUP(A1,'Tasks'!A1:C17,2,FALSE)
>> >which
>> > refers to looking up the 2nd column of the reference A1 on the sheet
>> > that
>> > the
>> > formula resides, but it only returns the formula not the requested
>> > information. My other columns work fine. The cell that A1 refers to
>> > is a
>> > drop down list but in the template it is as well. Any help?
>>
>>
>> .
>>


 | 
Pages: 1
Prev: Standard deviation and bell curve
Next: Need function to return numbers at beginning of text