Prev: pop up calender
Next: Used to return a worke sheet to origanan values
From: Jan Ogg on 14 Apr 2010 22:37
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?
From: "David Biddulph" groups [at] on 14 Apr 2010 22:47
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" <JanOgg(a)discussions.microsoft.com> wrote in message
news:FB9EF9D3-33BC-4EB2-90A1-43BCFE02DD20(a)microsoft.com...
> 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?


From: ozgrid.com on 14 Apr 2010 22:50
Use any cell format other than Text. Then re-enter you formulas or
Edit>Replace = with =


--
Regards
Dave Hawley
www.ozgrid.com
"Jan Ogg" <JanOgg(a)discussions.microsoft.com> wrote in message
news:FB9EF9D3-33BC-4EB2-90A1-43BCFE02DD20(a)microsoft.com...
> 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?

 | 
Pages: 1
Prev: pop up calender
Next: Used to return a worke sheet to origanan values