Excel issue with Function VLOOKUP -


i know might not best place ask purely excel question, but. have table following headers: number, date, name. in file need link number name. not in same order, hence vlookup formula. here data below. 

1   15-nov  allen   15-nov   10  15-nov  allen   15-nov   19  15-nov  allen   15-nov   6   5-mar   avalon  5-mar   15  5-mar   avalon  5-mar   24  5-mar   avalon  5-mar   9   15-nov  burg    15-nov   18  15-nov  burg    15-nov   27  15-nov  burg    15-nov   8   1-sep   fischer 1-sep   17  1-sep   fischer 1-sep   26  1-sep   fischer 1-sep   3   14-oct  kiser   14-oct   12  14-oct  kiser   14-oct   21  14-oct  kiser   14-oct   2   15-oct  remmert 15-oct   11  15-oct  remmert 15-oct   20  15-oct  remmert 15-oct   4   1-sep   roos    1-sep   13  1-sep   roos    1-sep   22  1-sep   roos    1-sep   7   6-feb   tomo    6-feb   16  6-feb   tomo    6-feb   25  6-feb   tomo    6-feb   5   1-jan   wash    1-jan   14  1-jan   wash    1-jan   23  1-jan   wash    1-jan

so lets assume titled column a, b, c, d. in new file in order grab name numbers used formula: 

=vlookup(a1,[workbook1]sheet1!$a$1:$d$27,3,false)

workbook1 , sheet1 data is. next need grab date file linking name. know can link number thing work , way arranged different dates oldest newest, not same one. date function in excel extremely stupid in opinion. used formula

=vlookup(b1,[workbook1]sheet1!$a$1:$d$27,1,false)

and iterations of replacing 1 4. keeps returning n/a. when change formatting of date general still returns nothing. dont doing wrong here.

i assume b1 holds name of person. in case, need adjust range lookup table, starts in column name, i.e.

=vlookup(b1,[workbook1]sheet1!$c$1:$d$27,2,false)

editted : change column 2 date


Comments

Post a Comment

Popular posts from this blog

javascript - Bootstrap Popover: iOS Safari strange behaviour -

i looking through twitter bootstrap documentation, , i'm interested in implementing dismissible popover when button clicked. here example bootstrap's docs: http://getbootstrap.com/javascript/#dismiss-on-next-click when press "dismissible popover" button os x safari browser works fine. when access same link above ios safari, button not work. is, popover not dismissed on click. why button not working ios safari? the example linked using data-trigger="focus" attribute. try changing data-trigger="click" . <a tabindex="0" class="btn btn-lg btn-danger" role="button" data-toggle="popover" data-trigger="click" title="dismissible popover" data-content="and here's amazing content. it's engaging. right?">dismissible popover</a>
Read more

Website Login Issue developed in magento -

i have website developed using magento . able login. right now, login failed. infact operations interacts user table failing. need know issue. how figure out? first clear try clear log file second make sure have not upgraded magento and 3rd make sure db accessible in magento -harry p
Read more

Can the constants be defined inside a model file of a framework in PHP? -

i'm using phpfox framework. i've define 2 constants used 2 functions present within model class file. can define constants @ beginning of model class file or cause issue or against coding standards? please me in regard. following 1 method model class file. i want write following code : <?php /** * [phpfox_header] */ /*header('content-type: text/event-stream'); header('cache-control: no-cache');*/ defined('phpfox') or exit('no dice!'); /** * * * @copyright [phpfox_copyright] * @author raymond benc * @package phpfox_service * @version $id: service.class.php 67 2009-01-20 11:32:45z raymond_benc $ */ class notification_service_process extends phpfox_service { /** * class constructor */ public function __construct() { $this->_stable = phpfox::gett('notification'); } public function add($stype, $iitemid, $iowneruserid, $isenderuserid = null) ...
Read more