Excel - VLOOKUP returning #VALUE -


yesterday asked this question. tried out vlookup formula seeing how useful was, have run strange error can't seem fix. have following row of data

probabilities| 1%, 1.9%, 4.6%, 9.3%, 16.2%, 25.9%, 37.5%, 50%, 62.5%, 74.1%, 83.8%, 90.7%, 95.4%, 98.1%

each item in it's own cell on separate sheet called "probability". on first sheet have =vlookup("probabilities",probability!$a$1:$o$1,a2+1,false) a2 number between 3 , 17. if a2 1, row header, "probabilities". if a2 >= 2 error: argument out of range: <whatever a2 +1>. i've tried adding headers, changing tables values integers or ="<some text>" see if didn't % symbol. cell a2 result of formula, tried type numbers directly cell well, , replacing a2 in formula number. i'm guessing issue not index. don't know what. in advance help. let me know if more info needed

if understand question correctly, want specific probability one-row table in sheet "probability". table has label in cell a1 , cells probability amounts spanning columns b through o. formula in cell a2 computes index number nth value in probability table. trying find formula return nth value.

this should work:

  =offset(probability!$a$1,0,$a$2,1,1)

the syntax offset "offset(cell_reference, row_offset, column_offset, height_in_rows, width_in_columns)", cell_reference anchor cell , row , column offsets indicate how many cells down (up if row offset negative) , right (left if column offset negative) want return value.

your formula should work (at least worked on machine). did #ref! error when used index value more number of columns in probability table, #n/a error when value string, , #value error when a2 sum of number , string.


Comments

Post a Comment

Popular posts from this blog

ios - iPhone/iPad different view orientations in different views , and apple approval process -

i force app's home screen portrait , other views landscape. apple rejects app if this? if not , how force first screen launch in portrait mode? , force other screens launch in landscape. this not duplicate question search every possible answer in website. i force app's home screen portrait , other views landscape. apple rejects app if this? no apple not reject app this. have lot of apps doesn't support orientation. forcing on 1 screen won't cause app reject. if not , how force first screen launch in portrait mode? , force other screens launch in landscape. can on write : -(nsuinteger)supportedinterfaceorientations; function.
Read more

java Extracting Zip file -

i'm looking way extract zip file. far have tried java.util.zip , org.apache.commons.compress, both gave corrupted output. basically, input zip file contain 1 single .doc file. java.util.zip: output corrupted. org.apache.commons.compress: output blank file, 2 mb size. so far commercial software winrar work perfectly. there java library make use of this? this method using java.util library: public void extractzipnative(file filezip) { zipinputstream zis; stringbuilder sb; try { zis = new zipinputstream(new fileinputstream(filezip)); zipentry ze = zis.getnextentry(); byte[] buffer = new byte[(int) ze.getsize()]; fileoutputstream fos = new fileoutputstream(this.tempfolderpath+ze.getname()); int len; while ((len=zis.read(buffer))>0) { fos.write(buffer); } fos.flush(); fos.close(); } catch (filenotfoundexception e) { // todo auto-generated catch block ...
Read more

C# WinForm - loading screen -

i ask how make loading screen (just picture or something) appears while program being loaded, , disappears when program has finished loading. in fancier versions, have seen process bar (%) displayed. how can have that, , how calculate % show on it? i know there form_load() event, not see form_loaded() event, or % property / attribute anywhere. all need create 1 form splash screen , show before main start showing landing page , close splash once landing page loaded. class splashform { //delegate cross thread call close private delegate void closedelegate(); //the type of form displayed splash screen. private static splashform splashform; static public void showsplashscreen() { // make sure launched once. if (splashform != null) return; thread thread = new thread(new threadstart(splashform.showform)); thread.isbackground = true; thread.setapartmentstate(apartmentstate.sta); thread....
Read more