VLOOKUP returning formula


J

Jan Ogg

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?
 
Ad

Advertisements

T

T. Valko

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.
 
J

Jan Ogg

That did it! Thank you so much.
Jan

T. Valko said:
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





.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top