Results 1 to 5 of 5

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Apr:2006
    Location: Gabrovo
    Posts: 42

    Ôóíêöèÿ â Excel

    Çäðàâåéòå, íÿêîé ùå ìîæå ëè äà ìè ïîìîãíå ìàëêî ñ Excel :]

    Íà ïúðâàòà ñòðàíèöà èìàì êàòàëîã ñ ïðîäóêòè - êàòàëîæåí íîìåð, íàèìåíîâàíèå, îïèñàíèå, êîëè÷åñòâî è ò.í.
    Èñêàì äà íàïðàâÿ òàêà, ÷å êîãàòî íà âòîðàòà ñòðàíèöà íàïèøåø êàòàëîæåí íîìåð äà òè èçâåäå èíôîðìàöèÿòà çà íåãî îò ïúðâà ñòðàíèöà.

    Äî íÿêúäå óñïÿõ äà ãî íàïðàâÿ ñ ôóíêöèÿòà VLOOKUP ïî òîçè óðîê:
    http://www.youtube.com/watch?v=vgb_rdI67Zs
    íî òàêà, êîãàòî âúâåäà íîìåð, êîéòî ãî íÿìà â ïúðâà ñòðàíèöà, ìè èçâåæäà ñòîéíîñòèòå îò äðóã íîìåð.

  2. #2
    Registered User
    Join Date: Oct:2003
    Location: Ñîôèÿ
    Posts: 4,317
    http://office.microsoft.com/bg-bg/ex...093351026.aspx
    Íàé-âåðîÿòíî íå ñè èçïîëçâàë FALSE çà ïîñëåäíèÿ ïàðàìåòúð.

  3. #3
    Registered User bpk's Avatar
    Join Date: Feb:2008
    Location: xxx
    Posts: 9,979
    +1
    ×åòâúðòèÿò ïàðàìåòúð íà ôóíêöèÿòà òðÿáâà äà å FALSE (èëè åêâèâàëåíòúò ìó çà ñúîòâåòíàòà åçèêîâà âåðñèÿ íà îôèñà).
    Òîé íå å çàäúëæèòåëåí, íî àêî ãî íÿìà ñå ïîäðàçáèðà TRUE - è ñå âçåìà íàé-áëèçêàòà íàëè÷íà ñòîéíîñò.
    24/7 Asus P9X79 Deluxe+H2O i7-3930K @4625 MHz+H2O 64 GB Geil DDR3 11-12-12-30/2333 MHz+H2O 2*HD7970 VaporX 6 GB+H2O ROG Phoebus+Onkyo HT-S990 THX RAID0:2*256 GB Samsung 830 SSD+RAID0:4*1TB WD1000DHTZ+..EXTs CM HAF-X Seasonic SS-1250XM Gold 1250W Logitech G15 Gaming+G9x 30" Dell 3007WFP-HC @2560x1600

  4. #4
    Registered User
    Join Date: Apr:2006
    Location: Gabrovo
    Posts: 42
    Áëàãîäàðÿ.
    À ìîãà ëè äà íàïðàâÿ ôóíêöèÿòà çà öÿëàòà êîëîíà è êîãàòî íÿìà ñòîéíîñò äà íå ìè èçâåæäà N/A à ïðîñòî êëåòêàòà äà îñòàíå ïðàçíà?
    Ñúùî è ìîãà ëè äà èçâàäÿ ñòîéíîñòèòå îò ïîâå÷å îò åäíà êîëîíà(âìîìåíòà èçïîëçâàì 2 ïúòè VLOOKUP çà äà èçâåäà äâå êîëîíè)
    Ïðèêà÷èõ ïðèìåðåí ôàéë, ñ òîâà êîåòî ñúì íàïðàâèë äî ñåãà.
    Attached Files
    Last edited by firefly; 31st July 2009 at 15:30.

  5. #5
    Registered User bpk's Avatar
    Join Date: Feb:2008
    Location: xxx
    Posts: 9,979
    Íå ìè ñå ÷åòàò ïðèìåðíè ôàéëîâå.

    ISNA(êëåòêà) - ïðîâåðÿâà äàëè â òàçè êëåòêà ñòîéíîñòòà å N/A.
    Çà äà äàäåø äðóãà ñòîéíîñò - ïîëçâàø IF
    Âñåêè VLOOKUP å îò åäíà êîëîíà - èíà÷å ìîæåø äà êîíêàòåíèðàø (çàëåïèø) ñòðèíãîâåòå âúðíàòè îò òÿõ.
    24/7 Asus P9X79 Deluxe+H2O i7-3930K @4625 MHz+H2O 64 GB Geil DDR3 11-12-12-30/2333 MHz+H2O 2*HD7970 VaporX 6 GB+H2O ROG Phoebus+Onkyo HT-S990 THX RAID0:2*256 GB Samsung 830 SSD+RAID0:4*1TB WD1000DHTZ+..EXTs CM HAF-X Seasonic SS-1250XM Gold 1250W Logitech G15 Gaming+G9x 30" Dell 3007WFP-HC @2560x1600

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 | Ìàãàçèí çà åëåêòðîííè öèãàðè