excel - VLOOKUP not returning right value - no error -


i have 2 worksheets inside of workbook use formulate report management.

a part of report includes override function in-case source data wrong / inaccurate, allows override data correct values.

i use vlookups check if resource name found in override tab, if is, return override value. working except 2 cells returning 0%. there no change in formula across sheet, other cells working except 1 cell , i'm totally stumped problem be.

formula used determine override value

=if($a2="","",if($b2<=c$1,0%,1)) (where c$1 date in header)

formula used in main sheet pick override

=if($a2 = "","",if(iserror(vlookup($a2,'manual override'!$a:f,6,false)),sumif('config pivots'!$d:$d,$a2,'config pivots'!bv:bv),vlookup($a2,'manual override'!$a:f,6,false)))

the issue seems in following line

vlookup($a2,'manual override'!$a:f,6,false) <-- returns 0 rather 100% 1 cell.

sample data below

                         override sheet            b              c           d          e           f name       end date     february 2015   march 2015  april 2015  may 2015    june 2015 joe        june 2015       100%           100%        100%       100%        100%                        main sheet - should            b              c               d          e           f           g name     override?       february 2015  march 2015  april 2015  may 2015    june 2015 joe         yes           100%           100%        100%       100%        100%                        main sheet - looks            b              c               d          e           f           g name     override?       february 2015  march 2015  april 2015  may 2015    june 2015 joe         yes           100%           100%        100%         100%          0%

found answer, had duplicate entry in override sheet. formula technically operating correctly, human error


-

Popular posts from this blog

html/hta mutiple file in audio player -

ok started coding .hta application , pretty html page .hta extension , adde mp3 player , did work <object data="test.mp3" type="audio/mp3" width="200" height="40"> <param name="src" value="test.mp3"> <param name="autostart" value="0"> </object> but it's 1 song playing again , again , plz there way add multiple files playlist believe it's should added "src" parameters not sure, i'm starting did add "," in between , , tried ";" none of them working i'm waiting answers :d i wanna know if can show me how become familiar tag see it's helpful , powerful activex, audio,video,pdf .... files i'm waiting impatiently [i don't know object, plz plz more clear] get inspired example hta_audio_player.hta <html> <head> <title>hackoo audio player playlist hackoo 2014</title> <hta:app...
Read more

debugging - Reference - What does this error mean in PHP? -

what this? this number of answers warnings, errors , notices might encounter while programming php , have no clue how fix. community wiki, invited participate in adding , maintaining list. why this? questions "headers sent" or "calling member of non-object" pop on stack overflow. root cause of questions same. answers questions typically repeat them , show op line change in his/her particular case. these answers not add value site because apply op's particular code. other users having same error can not read solution out of because localized. sad, because once understood root cause, fixing error trivial. hence, list tries explain solution in general way apply. what should here? if question has been marked duplicate of this, please find error message below , apply fix code. answers contain further links investigate in case shouldn't clear general answer alone. if want contribute, please add "favorite" error message, warning or notic...
Read more