Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Excel related query-Need help

 
sunita shaw
Ranch Hand
Posts: 45
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In my Excel matrix

1.VLOOKUP("Project Planning",C3:H3,6,FALSE) returened a "#N/A" when there is no "Project Planning" found in that cell .But I would like to replace "#N/A" by zero..How can I do that
2.I enabled a macro on my worksheet but when I am trying to disable or delete it...it just refuses to do so..How can i do it...

Plzz help
 
Chetan Parekh
Ranch Hand
Posts: 3640
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sunita!

Java people don�t play much with Microsoft Excel.

Better you try here.
[ March 07, 2006: Message edited by: Chetan Parekh ]
 
Ulf Dittmer
Rancher
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Java people don�t play much with Microsoft Excel.


I don't think that's a correct statement, but in any case - Excel questions fit into this forum.
 
Sameer Jamal
Ranch Hand
Posts: 1870
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic