Results 1 to 15 of 15

Thread: EXCEL

Hybrid View

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

    EXCEL

    Excel-a "" .

    Click image for larger version. 

Name:	справка.JPG 
Views:	96 
Size:	24.1 KB 
ID:	45147
    2 , 5 , 6 ( ) - ( ) = ......
    IF LOOKUP .

  2. #2
    feersum's Avatar
    Join Date: Dec:2009
    Location:
    Posts: 4,103
    ,

    - VLOOKUP.
    - .

    , sheet1, sheet 2.

    , .
    :

    =VLOOKUP(A:A;Sheet2!A:B;2;FALSE)

    :
    =VLOOKUP(A:A;Sheet2!A:B;2;FALSE)
    - Sheet1,

    =VLOOKUP(A:A;Sheet2!A:B;2;FALSE)
    Sheet2 B, ,

    =VLOOKUP(A:A;Sheet2!A:B;2;FALSE)
    (. - ),

    =VLOOKUP(A:A;Sheet2!A:B;2;FALSE) - .

    , :

    1 Firma 1 20 #N/A
    2 Firma 2 50 Firma 2
    3 Firma 3 120 #N/A
    4 Firma 4 15 #N/A
    5 Firma 5 180 Firma 5
    6 Firma 6 30 Firma 6

    #N/A -
    Firma X -

    , .

    , .
    "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
    Registered User
    Join Date: Nov:2011
    Location:
    Posts: 7

    2-

    =VLOOKUP(A:A;Sheet2!A:D;2;FALSE)
    D Sheet2 .
    ?

  4. #4
    feersum's Avatar
    Join Date: Dec:2009
    Location:
    Posts: 4,103
    :

    =VLOOKUP(A:A;Sheet2!A:D;4;FALSE)

    "4" - - , ( ), D - 4 .

    : , , #N/A - .
    .
    "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"

  5. #5
    Registered User
    Join Date: Nov:2011
    Location:
    Posts: 7
    .. #N/A #N/A " 0 "

  6. #6
    feersum's Avatar
    Join Date: Dec:2009
    Location:
    Posts: 4,103
    Quote Originally Posted by Nikolov5 View Post
    .. #N/A #N/A " 0 "
    .

    Copy Paste Special->Values, Search/Replace #N/A , , ...
    "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"

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 |