Results 1 to 9 of 9

Thread: Excel

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Nov:2011
    Location:
    Posts: 7

    Unhappy Excel

    , Excel .

    ... http://dox.bg/files/dw?a=1331f3324d


    Sheet- sheet2 Sheet 1.
    :
    =IF(ISNA(VLOOKUP(A:A;Sheet2!A:B;2;FALSE) );0;VLOOKUP(A:A;Sheet2!A:B;2;FALSE))
    Sheet1 Sheet2 2 B . 0. e

  2. #2
    feersum's Avatar
    Join Date: Dec:2009
    Location:
    Posts: 4,103
    IF, VLOOKUP?
    0 , ?
    VLOOKUP .
    "Comin' in on a wing and a prayer, Comin' in on a wing and a prayer, With our one motor gone, We can still carry on, Comin' in on a wing and a prayer"

  3. #3
    geek skrubalov's Avatar
    Join Date: Jan:2009
    Location:
    Posts: 769


    =IF(ISNA(VLOOKUP(C5;2!$C:$D;2;FALSE) );0;VLOOKUP(C5;2!$C:$D;2;FALSE))

    , , .


    =IF(ISNA(VLOOKUP(A1;Sheet2!$A:$B;2;FALSE ) );0;VLOOKUP(A1;Sheet2!$A:$B;2;FALSE))

    .
    Last edited by skrubalov; 20th April 2012 at 10:37. Reason:
    - - .

  4. #4
    Long Live Heavy Metal astromi's Avatar
    Join Date: Feb:2002
    Location:
    Posts: 347
    ( ):

    Code:
    =IF(ISNA(VLOOKUP(C:C;2!C:D;4;FALSE));0;VLOOKUP(C:C;2!C:D;4;FALSE))
    =IF(ISNA(VLOOKUP(C:C;2!C:D;1;FALSE));0;VLOOKUP(C:C;2!C:D;2;FALSE))
    
    =IF(ISNA(VLOOKUP(C:C;2!C:E;5;FALSE));0;VLOOKUP(C:C;2!C:E;5;FALSE))
    =IF(ISNA(VLOOKUP(C:C;2!C:E;1;FALSE));0;VLOOKUP(C:C;2!C:E;3;FALSE))

    VLOOKUP(lookup_value,table_array,col_ind ex_num,range_lookup)

    col_index_num table_array
    !

  5. #5
    geek skrubalov's Avatar
    Join Date: Jan:2009
    Location:
    Posts: 769
    , . - 2 .
    - - .

  6. #6
    Registered User
    Join Date: Nov:2011
    Location:
    Posts: 7
    - skrubalov ... col_index 2! 1!. ? .

  7. #7
    pimpirlit's Avatar
    Join Date: Mar:2004
    Location:
    Posts: 21,712
    ...
    !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |