Excel Vlookup error -


i have spreadsheet stored in shared location on website need vlookup on in order gather data. in order test have workbook stored in documents. have vba in workbook not affect data in question.

the formula attempting is

=vlookup("activated",$a4,4,true)

what need pull data several columns in sheet have not used vlookup in long time trying start small. have formatted of cells general has not helped.

i have tried

=vlookup("activated",$a2:$a71,4,true)

however #ref error

putting following return activated know in principal formula correct

=vlookup("activated",$a2:$a71,1,true)

i have looked @ answer submitted in excel vlookup #ref error has not resulted in correction of errors

any appreciated

the third argument column want return... there 1 column in range $a2:$a71 can't put 4 argument...

you need =vlookup("activated",$a2:$d71,4,true)

also should use false last argument, can return next closest match, if use true.

range_lookup logical value specifies whether want vlookup find exact match or approximate match:

http://office.microsoft.com/en-gb/excel-help/vlookup-hp005209335.aspx


Comments

Post a Comment

Popular posts from this blog

rdbms - what exactly the undo information lives in oracle? -

some docs says, there "undo tablespaces" implies should create tablespace undo imformation. some docs says, there "undo segment" implies undo information lives in normal tablespaces , use of it's segment. so, undo information lives , organized? earlier releases of oracle database used rollback segments store undo. oracle9i introduced automatic undo management, simplifies undo space management eliminating complexities associated rollback segment management. oracle recommends (oracle 9i , on words) use undo tablespace (automatic undo management) manage undo rather rollback segments. when creating undo tablespace, these automatically created: n undo segments (based on sessions parameter value) named _syssmun$ owned public (usable ops configuration) not manually manageable
Read more

bash - How do you programmatically add a bats test? -

i'd have bats test created every file in directory, i'm not sure best way done is. approach below creates single test when there many files in directory. #!/usr/bin/env bats in $(ls) @test "testing $i" { pwd } done to extract ls output not batter solution go wrong on filenames spaces. you can below shopt -s nullglob file in /dir/* //test command on $file done shopt -u nullglob you can using find command also find /some/directory -maxdepth 1 -type f -exec cmd option {} \;
Read more

clojure - 'get' replacement that throws exception on not found? -

i'd access values in maps , records, throwing exception when key isn't present. here's i've tried. there better strategy? this doesn't work because throw evaluated every time: (defn get-or-throw-1 [rec key] (get rec key (throw (exception. "no value.")))) maybe there's simple method using macro? well, isn't it; has same problem first definition, if evaluation of throw happens later: (defmacro get-or-throw-2 [rec key] `(get ~rec ~key (throw (exception. "no value.")))) this 1 works letting get return value (in theory) never generated other way: (defn get-or-throw-3 [rec key] (let [not-found-thing :i_would_never_name_some_thing_this_021138465079313 value (get rec key not-found-thing)] (if (= value not-found-thing) (throw (exception. "no value.")) value))) i don't having guess keywords or symbols never occur through other processes. (i use gensym generate special value of...
Read more