I am trying to build a function that will look up a value so that I can do a progressively addition of the values until no more values to look up
this prart of the function whitch is simple I just can't figure out why it won't work
i'm attaching the wook book see worksheet Area for highlighted cells were I'v been testing
Please Login or Register to view this content.
Last edited by CityMPLSEmpolyee; 04-06-2015 at 10:50 AM.
What results do you hope to see... and why?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
The values that you are looking up on CALCULATIONS column A are text values and the value being looked up is a real number.
You could multiply the values on CALCULATIONS column A from A20 on by 1 to change the text values to real numbers.
The formula in Area!B22 is referencing column 0.....no such thing so a N/A is the result.
Last edited by newdoverman; 04-03-2015 at 01:14 PM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
What I am trying to do is similar to worksheet "Depth", the deferens is instead of reporting the depths of each node I need to add the areas progressively.
but as I build a vlookup or an Index lookup function I'm getting N/A not the Value I'm Testing for witch is in Cell "CALCULATION!B70" (0.268356461).
Newdoverman
You are wright
Thank you very much
I’ve been working on this for a couple of days and thought that data was already numbers
You're welcome.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks