VLOOKUP just returns formula

J

Jan Ogg

Help, my VLOOKUP is just putting the formula into the cell.
=VLOOKUP(A13,'Tasks'!A2:D10,2,FALSE)
Where A13 is on same worksheet as the lookup cell.
What am I doing wrong?
 
O

ozgrid.com

Use any cell format other than Text. Then re-enter you formulas or
Edit>Replace = with =
 

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

Similar Threads

VLookup 1
VLOOKUP using the act shts tab name as a reference for the table_a 1
Formula not working 4
How to maintain a set range of cells when dragging a formula (e.gmonthly>annual data) 2
VLOOKUP with a blank cell 5
Excel Vlookup Help 0
vlookup table_array 4
VLOOKUP TABLE ERROR 6

Top