Results 1 to 5 of 5

Thread: EXCEL

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User hotris's Avatar
    Join Date: Dec:2007
    Location: Sofia
    Posts: 167

    EXCEL

    :Click image for larger version. 

Name:	firsttable.jpg 
Views:	84 
Size:	116.0 KB 
ID:	45744 :Click image for larger version. 

Name:	secondtable.jpg 
Views:	70 
Size:	134.7 KB 
ID:	45745
    . , .

  2. #2
    's Avatar
    Join Date: Mar:2005
    Location:
    Posts: 379
    , :
    =IF(ISNA(VLOOKUP(A1;'C:\...\[s1( ).xlsx]Sheet1'!$A:$B;2;0));100;VLOOKUP(A1;'C:\. ..\[s1( ).xlsx]Sheet1'!$A:$B;2;0)) . (Excel Options -> Trust Centre ->Trusted settings -> External Content -> Enable automatic update for all Workbook Links (not recommended) .
    , , , ,

  3. #3
    Registered User hotris's Avatar
    Join Date: Dec:2007
    Location: Sofia
    Posts: 167
    , , . . , . 100 .

  4. #4
    's Avatar
    Join Date: Mar:2005
    Location:
    Posts: 379
    - default- //sheet/. vlookup .
    , , , ,

  5. #5
    Registered User hotris's Avatar
    Join Date: Dec:2007
    Location: Sofia
    Posts: 167
    , , . . , .

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 |