Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Boell Fischer   on Dec 31 In MS Office Category.

  
Question Answered By: Akina Suzuki   on Dec 31

Actually I don't think the problem is using a reserved word. Using
"library" for a sheet  name doesn't cause any errors when trying a simpler
formula like =Library!C10+Sheet1!C8.

In any case  I found a roundabout to my problem. Aparently If I store the
sheet name in another cell  and then reference that cell in the formula it
works! (If anyone knows why please tell us)
I also made  the row  number column  on the initial sheet instead of library
sheet, so now I can do without the vlookup....
so my working  formula looks something like this
=INDIRECT(S4&"C"&R9) where S4 = Library! & R9= Row number

Share: 

 

This Question has 3 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Why Isn't this working? Or get search suggestion and latest updates.


Tagged: