ExcelBanter - VLOOKUP just returns formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - VLOOKUP just returns formula (https://www.excelbanter.com/excel-discussion-misc-queries/261548-vlookup-just-returns-formula.html)

Jan Ogg

VLOOKUP just returns formula

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?

David Biddulph[_2_]

VLOOKUP just returns formula

My guess is that you've got the cell formatted as text. Format the cell to
General, then go into edit mode & re-enter the formula.
--
David Biddulph

"Jan Ogg" wrote in message
...
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?

ozgrid.com

VLOOKUP just returns formula

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

--
Regards
Dave Hawley
www.ozgrid.com
"Jan Ogg" wrote in message
...
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?

All times are GMT +1. The time now is 01:43 PM.