VLOOKUP<\/b>, yani D\u00dc\u015eEYARA i\u015flevi, MS Excel ve Google E-Tablolar’da s\u0131kl\u0131kla kullan\u0131lan ve veri analizi konusunda olduk\u00e7a yararl\u0131 bir ara\u00e7t\u0131r. \u0130\u015flev, belirli bir de\u011feri arayarak ve e\u015fle\u015fen de\u011ferin bulundu\u011fu sat\u0131rdan belirli bir s\u00fctundaki de\u011feri d\u00f6nd\u00fcrerek \u00e7al\u0131\u015f\u0131r. Bu i\u015flev, \u00f6zellikle b\u00fcy\u00fck veri setlerinde belirli bilgileri h\u0131zl\u0131ca bulmak i\u00e7in idealdir.<\/p>\n D\u00dc\u015eEYARA \u0130\u015flevinin Kullan\u0131m\u0131 <\/h2>\n
S\u00f6zdizimi:<\/b><\/p>\n Bu i\u015flevin kullan\u0131m\u0131na dair iki g\u00fcnl\u00fck pratik \u00f6rnek ele alal\u0131m:<\/p>\n Varsayal\u0131m ki, \u015firket \u00e7al\u0131\u015fanlar\u0131n\u0131n listesini ve onlar\u0131n departmanlar\u0131n\u0131 i\u00e7eren bir veritaban\u0131n\u0131z var ve belli bir \u00e7al\u0131\u015fan\u0131n departman bilgisini bulmak istiyorsunuz. <\/p>\n Bu form\u00fclde “Ahmet Y\u0131ld\u0131z” aranan_de\u011fer, A2:B100 arama yap\u0131lan aral\u0131k, 2 \u00e7al\u0131\u015fan\u0131n departman bilgisinin \u00e7ekilece\u011fi s\u00fctun numaras\u0131 ve FALSE tam e\u015fle\u015fme zorunlulu\u011funu belirten parametredir. <\/p>\n Diyelim ki, farkl\u0131 \u00fcr\u00fcnlerin sat\u0131\u015f miktarlar\u0131n\u0131 ve bu \u00fcr\u00fcnlerin fiyatlar\u0131n\u0131 i\u00e7eren bir tablonuz var. Belli bir \u00fcr\u00fcn\u00fcn sat\u0131\u015f fiyat\u0131n\u0131 bulmak istiyorsunuz.<\/p>\n Burada “Elma”, aranacak \u00fcr\u00fcn ad\u0131d\u0131r (aranan_de\u011fer). A2:C300 aral\u0131\u011f\u0131ndaki veriler i\u00e7inde arama yap\u0131l\u0131r. 3 s\u00fctun indeksi sat\u0131\u015f fiyat\u0131na i\u015faret eder ve TRUE parametresi, e\u015fle\u015fen en yak\u0131n de\u011feri d\u00f6ner (\u00f6rne\u011fin, “Elma” yerine “Elmalar” ge\u00e7se bile).<\/p>\n Yukar\u0131daki \u00f6rnekler, D\u00dc\u015eEYARA i\u015flevinin i\u015f ak\u0131\u015f\u0131n\u0131z\u0131 ne \u015fekilde kolayla\u015ft\u0131rabilece\u011fini g\u00f6stermektedir. Do\u011fru kullan\u0131ld\u0131\u011f\u0131nda, bu i\u015flev veri y\u00f6netimini olduk\u00e7a h\u0131zland\u0131rabilir ve hata riskini azaltabilir.<\/p>\n","protected":false},"excerpt":{"rendered":" Bir dizinin ilk s\u00fctununa bakar ve bir h\u00fccrenin de\u011ferini vermek i\u00e7in sat\u0131r boyunca hareket eder<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[579],"tags":[],"class_list":["post-15708","post","type-post","status-publish","format-standard","hentry","category-arama-ve-basvuru"],"acf":[],"yoast_head":"\nVLOOKUP(aranan_de\u011fer, aral\u0131k, s\u00fctun_index_numaras\u0131, yak\u0131nsama)<\/code><\/pre>\n\n
Pratik Uygulamalar ve \u00c7\u00f6z\u00fcmler <\/h2>\n
\u00d6rnekle \u00c7al\u0131\u015fanlar Listesinden Bilgi Almak <\/h2>\n
=VLOOKUP(\"Ahmet Y\u0131ld\u0131z\", A2:B100, 2, FALSE) <\/code> <\/pre>\n Sat\u0131\u015f Verilerinden Belirli \u00dcr\u00fcn Bilgilerini \u00c7ekmek <\/h2>\n
=VLOOKUP(\"Elma\", A2:C300, 3, TRUE) <\/code> <\/pre>\n