PDA

Orijinalini görmek için tıklayınız : EĞER VE DÜŞEYARA



kenevir47
17.03.2014, 22:55
Merhaba arkadaşlar.
Forumda yeniyim eğer ve düşeyara formülü kullanarak (Mükellef sayfasından b 2 sütununda başlayarak şirketin Adresini ve şube adres ve kiraya verenin bilgilerini Kira sayfasında o12 hücresinde sağlanmasını istiyorum yalnız j3 te mükellefin dosya numarası var ve j5 te ise Merkez Ve Şube seçenekleri var j5 hücresine merkez yazdığımda merkeze ait adres bilgilerini yani Mükellef sayfasından D,E,F,G,H hücrelerindeki ni birleştirerek Kira o12 hücresine getirsin aynı şekilde Şube ye ait adres bilgilerinide olmasını nasıl sağlayabilirim teşekkür ederim Önek dosyasını gönderiyorum
Not: sanırım 16 tane ğer geçiyor aynı hücrede.

Mahir
18.03.2014, 00:40
Merhaba,

Tablo ekler misiniz?
http://www.hesaptablosu.com/showthread.php/5129-ExceltoHTML

kenevir47
20.03.2014, 20:06
Merhaba Mahir bey.

Ekte de göreceğiniz gibi 3 ayrı sayfa hazırlamışım Mükellef, Hizmet Sözleşme, ve Kira.
Hizmet sözleşme sayfasında (R1) hücresine 1 yazdığımda ("1" firmalarıma ait dosya numarasıdır Mükellef Sayfasında) yazdığımda ve (R2) de "MERKEZ" Seçtikten sonra "Mükellef" sayfasından Merkeze ait Adres Bilgilerini (O12) hücresine aktarsın,
aynı şekilde (R2) hücresine Şube Yazdığımda Mükellef sayfasından Merkeze ait Şube (1), dediğimde Şube (1) e ait Şube (2), Dediğimde Şube (2) ye ait bilgileri getirsin ve diğer Şube (3), Şube (4) Şube (5) içinde yapmak istiyorum ve Kiraya verenin eğer ve düşeyara formülünü kullandım fakat 5 tane eğer den sonra istediğim bilgileri vermiyor.

<table border=1><tr><td align=left valign=center><font size=1 color=red face=verdana><b>Gönderen XL Ver.:</b></font><font size=1 face=verdana> bilinmiyor / </font><font size=1 color=red face=verdana><b>OS Ver.:</b></font><font size=1 face=verdana> </font></td></tr><tr valign=top><td><table border=0 bgcolor=d4d0c8 cellspacing=1 cellpadding=1 align=center><tr align=center valign=center bgcolor=white><td bgcolor=d4d0c8 align=center><font color=black size=2>+</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>A</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>B</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>C</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>D</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>E</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>F</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>G</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>H</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>I</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>J</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>K</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>L</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>M</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>N</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>O</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>P</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>Q</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>R</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>S</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>T</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>1</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>2</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white><b></b></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana><b>Merkez</b></font></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>3</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white><b></b></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>4</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white><b></b></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>5</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>6</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white><b></b></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Sayı :</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana><b>220142014288</b></font></td><td bgcolor=white><b></b></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>7</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana><b> S Ö Z L E Ş M E</b></font></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Tarih :</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana><b>01/01/2014</b></font></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>8</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>9</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white><b></b></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>23230</font></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>10</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1- TARAFLAR</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana> MESLEK MENSUBUNUN</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>İŞ SAHİBİNİN</font></td><td bgcolor=white></td><td bgcolor=white><b></b></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>11</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Adı Soyadı / Unvanı</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>:</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>MEHMET KARAKAŞ</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white nowrap=true align=center><font size=1 color=black face=verdana><ACRONYM title='=EĞER($R$1;DÜŞEYARA($R$1;Mükellef!$A$3:$GV$ 5;2;YANLIŞ))&" "&EĞER($R$1;DÜŞEYARA($R$1;Mükellef!$A$2:$C$8;3;YANLI Ş))'>IŞIL BOYA İNŞAAT TİC. LTD.ŞTİ <b>(ƒx)</b></ACRONYM></font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>12</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Adres</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>:</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>xxxxxxxx</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white nowrap=true align=center><font size=1 color=black face=verdana><ACRONYM title='=EĞER($R$1;DÜŞEYARA($R$1;Mükellef!$A$2:$Z$8 ;4;YANLIŞ))&" "&EĞER($R$1;DÜŞEYARA($R$1;Mükellef!$A$2:$Z$8;6;"YANLIŞ"))&" NO. "&EĞER($R$1;DÜŞEYARA($R$1;Mükellef!$A$2:$Z$8;7;"YANLIŞ"))&" / "&EĞER($R$1;DÜŞEYARA($R$1;Mükellef!$A$2:$Z$8;8;"YANLIŞ"))&" " '>NUR İY.CADDES NO. 355 / E SİLOPİ / ŞIRNAK <b>(ƒx)</b></ACRONYM></font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>13</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>14</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>15</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Telefon</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>:</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>xxx</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>534-2435</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>16</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Vergi D. Vergi Kimlik No.</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>:</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>xxx</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>xxx</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>xxx</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>000 534 2435</font></td><td bgcolor=white></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>17</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Bağlı Olduğu Mesleki</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>:</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>xxx</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>xxx</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>18</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Kuruluş/Büro Sicil No.</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>:</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>ODA:</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>xxx</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BÜRO:</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>xx</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white nowrap=true align=center><font size=1 color=black face=verdana><ACRONYM title='=EĞER(EHATALIYSA(DÜŞEYARA($R$1;Mükellef!$A$ 2:$DC$66;38;0));"";DÜŞEYARA($R$1;Mükellef!$A$2:$DC$66;47;0))'>12.30.1899 <b>(ƒx)</b></ACRONYM></font></td><td bgcolor=white></td><td bgcolor=white nowrap=true align=center><font size=1 color=black face=verdana><ACRONYM title='=EĞER(EHATALIYSA(DÜŞEYARA($R$1;Mükellef!$A$ 2:$DC$66;10;0));"";DÜŞEYARA($R$1;Mükellef!$A$2:$DC$66;10;0))'>00809 <b>(ƒx)</b></ACRONYM></font></td><td bgcolor=white></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td></tr></table></td></tr><tr><td bgcolor=f0f8ff align=center><font color=black size=1 face=verdana><b>XLtoHTML v1.1 / OfficeTürkiye - 2010©</b></font></td></tr></table>

kenevir47
20.03.2014, 20:07
Mükellef Sayfası

<table border=1><tr><td align=left valign=center><font size=1 color=red face=verdana><b>Gönderen XL Ver.:</b></font><font size=1 face=verdana> bilinmiyor / </font><font size=1 color=red face=verdana><b>OS Ver.:</b></font><font size=1 face=verdana> </font></td></tr><tr valign=top><td><table border=0 bgcolor=d4d0c8 cellspacing=1 cellpadding=1 align=center><tr align=center valign=center bgcolor=white><td bgcolor=d4d0c8 align=center><font color=black size=2>+</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>A</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>B</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>C</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>D</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>E</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>F</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>G</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>H</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>I</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>J</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>K</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>L</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>M</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>N</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>O</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>P</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>Q</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>R</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>1</font></td><td bgcolor=yellow nowrap=true><font size=1 color=black face=verdana><b>MERKEZE AİT BİLGİLER</b></font></td><td bgcolor=yellow><b></b></td><td bgcolor=yellow><b></b></td><td bgcolor=yellow><b></b></td><td bgcolor=yellow><b></b></td><td bgcolor=yellow><b></b></td><td bgcolor=yellow><b></b></td><td bgcolor=yellow><b></b></td><td bgcolor=yellow><b></b></td><td bgcolor=yellow><b></b></td><td bgcolor=yellow><b></b></td><td bgcolor=yellow><b></b></td><td bgcolor=yellow><b></b></td><td bgcolor=yellow><b></b></td><td bgcolor=#FFCC00 nowrap=true><font size=1 color=black face=verdana>MERKEZE AİT KİRA BİLGİLERİ</font></td><td bgcolor=#FFCC00></td><td bgcolor=#FFCC00></td><td bgcolor=#FFCC00></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>2</font></td><td bgcolor=yellow nowrap=true><font size=1 color=black face=verdana><b>FİRMA NO</b></font></td><td bgcolor=yellow nowrap=true><font size=1 color=black face=verdana>ADI / UNVANI</font></td><td bgcolor=yellow nowrap=true><font size=1 color=black face=verdana>SOYADI</font></td><td bgcolor=yellow nowrap=true><font size=1 color=black face=verdana>MAHALLE</font></td><td bgcolor=yellow nowrap=true><font size=1 color=black face=verdana>SOKAK</font></td><td bgcolor=yellow nowrap=true><font size=1 color=black face=verdana>CADDE</font></td><td bgcolor=yellow nowrap=true><font size=1 color=black face=verdana>KAPI NO</font></td><td bgcolor=yellow nowrap=true><font size=1 color=black face=verdana>İÇ KAPI</font></td><td bgcolor=yellow nowrap=true><font size=1 color=black face=verdana>ADRES KD</font></td><td bgcolor=yellow nowrap=true><font size=1 color=black face=verdana>MERNİS</font></td><td bgcolor=yellow nowrap=true><font size=1 color=black face=verdana>D.Yeri</font></td><td bgcolor=yellow nowrap=true><font size=1 color=black face=verdana>TC -KİMLİK NO.</font></td><td bgcolor=yellow nowrap=true><font size=1 color=black face=verdana>VERGİ
HESAP NO</font></td><td bgcolor=yellow nowrap=true><font size=1 color=black face=verdana>e-mail</font></td><td bgcolor=#FFCC00 nowrap=true><font size=1 color=black face=verdana>KİRAYA VERENİN ADI SOYADI</font></td><td bgcolor=#FFCC00 nowrap=true><font size=1 color=black face=verdana>T.C</font></td><td bgcolor=#FFCC00 nowrap=true><font size=1 color=black face=verdana>ADRES</font></td><td bgcolor=#FFCC00 nowrap=true><font size=1 color=black face=verdana>ADRES KODU</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>3</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana><b>1</b></font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>IŞIL BOYA İNŞAAT TİC. LTD.ŞTİ</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>NUR</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>İY.CADDES</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>355</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>E</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>8808527185271</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>000809</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>SİLOPİ</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>468 023 7642</font></td><td bgcolor=white nowrap=true><font size=1 color=blue face=verdana>@hotmail.hotmail.</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>EMİN</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>T.C</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>KİRAYA VERENİN ADRESİ</font></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>4</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana><b>2</b></font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Abdulbari</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Tekin</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>YEŞİL</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>105.Sk.</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>3.cadde</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>15</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>F</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>4569873</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>4569 872 1315</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Mehmet</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>T.C</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>KİRAYA VERENİN ADRESİ</font></td><td bgcolor=white></td></tr></table></td></tr><tr><td bgcolor=f0f8ff align=center><font color=black size=1 face=verdana><b>XLtoHTML v1.1 / OfficeTürkiye - 2010©</b></font></td></tr></table>

kenevir47
20.03.2014, 20:09
ŞUBE(1) BİLGİLERİ SATIR-3 YAZISININ KARŞISINDA SAĞA DOĞRU KOLON HARFLERİDİR.
<table border=1><tr><td align=left valign=center><font size=1 color=red face=verdana><b>Gönderen XL Ver.:</b></font><font size=1 face=verdana> bilinmiyor / </font><font size=1 color=red face=verdana><b>OS Ver.:</b></font><font size=1 face=verdana> </font></td></tr><tr valign=top><td><table border=0 bgcolor=d4d0c8 cellspacing=1 cellpadding=1 align=center><tr align=center valign=center bgcolor=white><td bgcolor=d4d0c8 align=center><font color=black size=2>+</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>A</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>B</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>C</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>D</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>E</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>F</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>G</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>H</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>I</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>J</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>K</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>1</font></td><td bgcolor=yellow><b></b></td><td bgcolor=#00CCFF nowrap=true><font size=1 color=black face=verdana>ŞUBE (1) E AİT KİRA VE ADRES BİLGİLERİ</font></td><td bgcolor=#00CCFF></td><td bgcolor=#00CCFF></td><td bgcolor=#00CCFF></td><td bgcolor=#00CCFF></td><td bgcolor=#00CCFF></td><td bgcolor=#00CCFF></td><td bgcolor=#00CCFF></td><td bgcolor=#00CCFF></td><td bgcolor=#00CCFF></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>2</font></td><td bgcolor=yellow nowrap=true><font size=1 color=black face=verdana><b>FİRMA NO</b></font></td><td bgcolor=#00CCFF nowrap=true><font size=1 color=black face=verdana>KİRAYA VERENİN ADI SOYADI</font></td><td bgcolor=#00CCFF nowrap=true><font size=1 color=black face=verdana>T.C</font></td><td bgcolor=#00CCFF nowrap=true><font size=1 color=black face=verdana>ADRES</font></td><td bgcolor=#00CCFF nowrap=true><font size=1 color=black face=verdana>ADRES KODU</font></td><td bgcolor=#00CCFF nowrap=true><font size=1 color=black face=verdana>ŞUBE ADRESİ
MAHALLES</font></td><td bgcolor=#00CCFF nowrap=true><font size=1 color=black face=verdana>SOKAK</font></td><td bgcolor=#00CCFF nowrap=true><font size=1 color=black face=verdana>CADDE</font></td><td bgcolor=#00CCFF nowrap=true><font size=1 color=black face=verdana>DIŞ KAPI
NO.</font></td><td bgcolor=#00CCFF nowrap=true><font size=1 color=black face=verdana>İÇ KAPI
NO.</font></td><td bgcolor=#00CCFF nowrap=true><font size=1 color=black face=verdana>ADRES KODU</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>3</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana><b>1</b></font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>HACİ TANGUT</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>414102413298624132986</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>y.tepe mah.</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1975951975950963963</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Barbaros Mah.</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>50892.sokak</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>65.cadde</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>51</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>B</font></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>4</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana><b>SATIR-3</b></font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BE</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BF</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BG</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BH</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BI</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BJ</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BK</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BL</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BM</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BN</font></td></tr></table></td></tr><tr><td bgcolor=f0f8ff align=center><font color=black size=1 face=verdana><b>XLtoHTML v1.1 / OfficeTürkiye - 2010©</b></font></td></tr></table>

kenevir47
20.03.2014, 20:23
ŞUBE(2) BİLGİLERİ SATIR-3 YAZISININ KARŞISINDA SAĞA DOĞRU KOLON HARFLERİDİR.
<table border=1><tr><td align=left valign=center><font size=1 color=red face=verdana><b>Gönderen XL Ver.:</b></font><font size=1 face=verdana> bilinmiyor / </font><font size=1 color=red face=verdana><b>OS Ver.:</b></font><font size=1 face=verdana> </font></td></tr><tr valign=top><td><table border=0 bgcolor=d4d0c8 cellspacing=1 cellpadding=1 align=center><tr align=center valign=center bgcolor=white><td bgcolor=d4d0c8 align=center><font color=black size=2>+</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>L</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>M</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>N</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>O</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>P</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>Q</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>R</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>S</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>T</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>1</font></td><td bgcolor=#FFCC99 nowrap=true><font size=1 color=black face=verdana>ŞUBE (2) E AİT KİRA VE ADRES BİLGİLERİ</font></td><td bgcolor=#FFCC99></td><td bgcolor=#FFCC99></td><td bgcolor=#FFCC99></td><td bgcolor=#FFCC99></td><td bgcolor=#FFCC99></td><td bgcolor=#FFCC99></td><td bgcolor=#FFCC99></td><td bgcolor=#FFCC99></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>2</font></td><td bgcolor=#FFCC99 nowrap=true><font size=1 color=black face=verdana>KİRAYA VERENİN ADI SOYADI</font></td><td bgcolor=#FFCC99 nowrap=true><font size=1 color=black face=verdana>T.C</font></td><td bgcolor=#FFCC99 nowrap=true><font size=1 color=black face=verdana>ADRES</font></td><td bgcolor=#FFCC99 nowrap=true><font size=1 color=black face=verdana>ADRES KODU</font></td><td bgcolor=#FFCC99 nowrap=true><font size=1 color=black face=verdana>ŞUBE ADRESİ
MAHALLES</font></td><td bgcolor=#FFCC99 nowrap=true><font size=1 color=black face=verdana>SOKAK</font></td><td bgcolor=#FFCC99 nowrap=true><font size=1 color=black face=verdana>CADDE</font></td><td bgcolor=#FFCC99 nowrap=true><font size=1 color=black face=verdana>DIŞ KAPI
NO.</font></td><td bgcolor=#FFCC99 nowrap=true><font size=1 color=black face=verdana>İÇ KAPI
NO.</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>3</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Ahmet Berkin</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>123456789112345678910</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>xxxxxxx xxx xx</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1975951975950963963</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>YEŞİLTEPE</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>2.CADDE</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>51</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>B</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>4</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BO</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BP</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BQ</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BR</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BS</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BT</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BU</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BV</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BW</font></td></tr></table></td></tr><tr><td bgcolor=f0f8ff align=center><font color=black size=1 face=verdana><b>XLtoHTML v1.1 / OfficeTürkiye - 2010©</b></font></td></tr></table>

kenevir47
20.03.2014, 20:25
ŞUBE(3) BİLGİLERİ SATIR-3 YAZISININ KARŞISINDA SAĞA DOĞRU KOLON HARFLERİDİR.
<table border=1><tr><td align=left valign=center><font size=1 color=red face=verdana><b>Gönderen XL Ver.:</b></font><font size=1 face=verdana> bilinmiyor / </font><font size=1 color=red face=verdana><b>OS Ver.:</b></font><font size=1 face=verdana> </font></td></tr><tr valign=top><td><table border=0 bgcolor=d4d0c8 cellspacing=1 cellpadding=1 align=center><tr align=center valign=center bgcolor=white><td bgcolor=d4d0c8 align=center><font color=black size=2>+</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>A</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>B</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>C</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>D</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>E</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>F</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>G</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>H</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>I</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>J</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>1</font></td><td bgcolor=yellow><b></b></td><td bgcolor=#CCCCFF nowrap=true><font size=1 color=black face=verdana>ŞUBE (3) E AİT KİRA VE ADRES BİLGİLERİ</font></td><td bgcolor=#CCCCFF></td><td bgcolor=#CCCCFF></td><td bgcolor=#CCCCFF></td><td bgcolor=#CCCCFF></td><td bgcolor=#CCCCFF></td><td bgcolor=#CCCCFF></td><td bgcolor=#CCCCFF></td><td bgcolor=#CCCCFF></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>2</font></td><td bgcolor=yellow nowrap=true><font size=1 color=black face=verdana><b>FİRMA NO</b></font></td><td bgcolor=#CCCCFF nowrap=true><font size=1 color=black face=verdana>KİRAYA VERENİN ADI SOYADI</font></td><td bgcolor=#CCCCFF nowrap=true><font size=1 color=black face=verdana>T.C</font></td><td bgcolor=#CCCCFF nowrap=true><font size=1 color=black face=verdana>ADRES</font></td><td bgcolor=#CCCCFF nowrap=true><font size=1 color=black face=verdana>ADRES KODU</font></td><td bgcolor=#CCCCFF nowrap=true><font size=1 color=black face=verdana>ŞUBE ADRESİ
MAHALLES</font></td><td bgcolor=#CCCCFF nowrap=true><font size=1 color=black face=verdana>SOKAK</font></td><td bgcolor=#CCCCFF nowrap=true><font size=1 color=black face=verdana>CADDE</font></td><td bgcolor=#CCCCFF nowrap=true><font size=1 color=black face=verdana>DIŞ KAPI
NO.</font></td><td bgcolor=#CCCCFF nowrap=true><font size=1 color=black face=verdana>İÇ KAPI
NO.</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>3</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana><b>1</b></font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>HACİ TANGUT</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>414102413287224132872</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>YEŞİLTEPE MAHALLESİ 604.SOKAK NO. </font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1975951975950963963</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>YEŞİLTEPE</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>2.CADDE</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>51</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>B</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>4</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana><b>SATIR-3</b></font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BX</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BY</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BZ</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>CA</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>CB</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>CC</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>CD</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>CE</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>CF</font></td></tr></table></td></tr><tr><td bgcolor=f0f8ff align=center><font color=black size=1 face=verdana><b>XLtoHTML v1.1 / OfficeTürkiye - 2010©</b></font></td></tr></table>

kenevir47
20.03.2014, 20:27
ŞUBE(4) BİLGİLERİ SATIR-3 YAZISININ KARŞISINDA SAĞA DOĞRU KOLON HARFLERİDİR.
<table border=1><tr><td align=left valign=center><font size=1 color=red face=verdana><b>Gönderen XL Ver.:</b></font><font size=1 face=verdana> bilinmiyor / </font><font size=1 color=red face=verdana><b>OS Ver.:</b></font><font size=1 face=verdana> </font></td></tr><tr valign=top><td><table border=0 bgcolor=d4d0c8 cellspacing=1 cellpadding=1 align=center><tr align=center valign=center bgcolor=white><td bgcolor=d4d0c8 align=center><font color=black size=2>+</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>K</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>L</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>M</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>N</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>O</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>P</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>Q</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>R</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>S</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>1</font></td><td bgcolor=#CCFFCC nowrap=true><font size=1 color=black face=verdana>ŞUBE (4) E AİT KİRA VE ADRES BİLGİLERİ</font></td><td bgcolor=#CCFFCC></td><td bgcolor=#CCFFCC></td><td bgcolor=#CCFFCC></td><td bgcolor=#CCFFCC></td><td bgcolor=#CCFFCC></td><td bgcolor=#CCFFCC></td><td bgcolor=#CCFFCC></td><td bgcolor=#CCFFCC></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>2</font></td><td bgcolor=#CCFFCC nowrap=true><font size=1 color=black face=verdana>KİRAYA VERENİN ADI SOYADI</font></td><td bgcolor=#CCFFCC nowrap=true><font size=1 color=black face=verdana>T.C</font></td><td bgcolor=#CCFFCC nowrap=true><font size=1 color=black face=verdana>ADRES</font></td><td bgcolor=#CCFFCC nowrap=true><font size=1 color=black face=verdana>ADRES KODU</font></td><td bgcolor=#CCFFCC nowrap=true><font size=1 color=black face=verdana>ŞUBE ADRESİ
MAHALLES</font></td><td bgcolor=#CCFFCC nowrap=true><font size=1 color=black face=verdana>SOKAK</font></td><td bgcolor=#CCFFCC nowrap=true><font size=1 color=black face=verdana>CADDE</font></td><td bgcolor=#CCFFCC nowrap=true><font size=1 color=black face=verdana>DIŞ KAPI
NO.</font></td><td bgcolor=#CCFFCC nowrap=true><font size=1 color=black face=verdana>İÇ KAPI
NO.</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>3</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>HACİ TANGUT</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>414102413287224132872</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>YEŞİLTEPE MAHALLESİ 604.SOKAK NO. </font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1975951975950963963</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>YEŞİLTEPE</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>2.CADDE</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>51</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>B</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>4</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>CG</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>CH</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>CI</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>CJ</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>CK</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>CL</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>CM</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>CN</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>CO</font></td></tr></table></td></tr><tr><td bgcolor=f0f8ff align=center><font color=black size=1 face=verdana><b>XLtoHTML v1.1 / OfficeTürkiye - 2010©</b></font></td></tr></table>

kenevir47
20.03.2014, 20:29
İLGİLİ hücrelere aşağıdaki eğer ve düşeyara formülünü kullandım fakat başaramadım.
1-) =EĞER($J$5="ŞUBE-1";DÜŞEYARA($J$3;Mükellef!$A$2:$FD$6;66;YANLIŞ)&" "&EĞER($J$5="ŞUBE-1";DÜŞEYARA($J$3;Mükellef!$A$2:$FD$6;67;YANLIŞ)&" ")&EĞER($J$5="ŞUBE-1";DÜŞEYARA($J$3;Mükellef!$A$2:$FD$6;68;YANLIŞ)&" NO.")&" "&EĞER($J$5="ŞUBE-1";DÜŞEYARA($J$3;Mükellef!$A$2:$FD$6;69;YANLIŞ)&"/"&EĞER($J$5="ŞUBE-1";DÜŞEYARA($J$3;Mükellef!$A$2:$FD$6;70;YANLIŞ)&" ")&" "&EĞER($J$5="ŞUBE-1";DÜŞEYARA($J$3;Mükellef!$A$2:$FD$6;71;YANLIŞ)

1. Seçenekteki formüller o şekilde kullandığımda (ŞUBEYE AİT Bilgileri doğru şekilde veriyor ancak 2. Seçenekte ise MERKEZE Ait Bilgilere gelince işler değişiyor bundan sonraki sorunu ortadan kaldırmam için ne yapmam lazım)

2-) &" "&EĞER($J$5="MERKEZ";DÜŞEYARA($J$3;Mükellef!$A$2:$K$6;4;YANLIŞ)&" "&EĞER($J$5="MERKEZ";DÜŞEYARA($J$3;Mükellef!$A$2:$K$6;5;YANLIŞ)&" "&EĞER($J$5="MERKEZ";DÜŞEYARA($J$3;Mükellef!$A$2:$K$6;6;YANLIŞ)&" NO: "&EĞER($J$5="MERKEZ";DÜŞEYARA($J$3;Mükellef!$A$2:$K$6;7;YANLIŞ)&" / ")&EĞER($J$5="MERKEZ";DÜŞEYARA($J$3;Mükellef!$A$2:$K$6;8;YANLIŞ)&" İLÇE / İL")))))))

kenevir47
21.03.2014, 15:43
cevap verecek biri yokmu

ataköylü-59
22.03.2014, 13:15
Sayın kenevir47;
Tablonuz benim için oldukça karmaşık görünüyor. Ancak yukarıdaki yazınızdan anladığım kadarıyla iç içe en fazla 5 Eğer işlevi doğru sonuç üretiyor demişsiniz Kullandığınız ofis versiyonu 2010 ise daha fazlasını kullanmanıza imkan sağlıyor. Ama 2003 versiyonunda sadece 5 Eğer kullanılabiliyordu. Fakat 5 nci EĞER den sonra fonksiyonun sonuna + işareti koyup diğer EĞER lere de devam edilebiliyordu. Birde bunu deneseniz diyorum. Sanırım üstadlar tablonuza bir çözüm bulacaklardır.

kenevir47
22.03.2014, 22:41
Sayın Ataköylü-59 teşekkür ederim.
Office 2010 kullanıyorum

kenevir47
23.03.2014, 01:18
Formülü çözdüm fakat tabloda görüldüğü gibi adres sonuna (YANLIŞ) yazısı görünüyor ve aynı şekilde Şube seçtiğimde bu sefer adresin sol başa (YANLIŞ) yazısı görünüyor
<table border=1><tr><td align=left valign=center><font size=1 color=red face=verdana><b>Gönderen XL Ver.:</b></font><font size=1 face=verdana> bilinmiyor / </font><font size=1 color=red face=verdana><b>OS Ver.:</b></font><font size=1 face=verdana> </font></td></tr><tr valign=top><td><table border=0 bgcolor=d4d0c8 cellspacing=1 cellpadding=1 align=center><tr align=center valign=center bgcolor=white><td bgcolor=d4d0c8 align=center><font color=black size=2>+</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>I</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>J</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>K</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>L</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>M</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>N</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>O</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>P</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>Q</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>R</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>S</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>T</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>1</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>200</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>2</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>3</font></td><td bgcolor=white><b></b></td><td bgcolor=yellow nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>4</font></td><td bgcolor=white><b></b></td><td bgcolor=yellow></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>5</font></td><td bgcolor=white><b></b></td><td bgcolor=yellow nowrap=true><font size=1 color=black face=verdana>MERKEZ</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white nowrap=true align=center><font size=1 color=black face=verdana><ACRONYM title='=" " $J$5="MERKEZ" DÜŞEYARA($J$3;Mükellef!$A$2:$H$6;4;0)&" " $J$5="MERKEZ" DÜŞEYARA($J$3;Mükellef!$A$2:$H$6;5;0)&" " $J$5="MERKEZ" DÜŞEYARA($J$3;Mükellef!$A$2:$H$6;6;0)&" NO: "&EĞER($J$5="MERKEZ";DÜŞEYARA($J$3;Mükellef!$A$2:$H$6;7;0)&"/") '> CUMHURİYET 589 İPEKYOL CADDESİ NO: 355/E SİLOPİ ŞIRNAK YANLIŞ <b>(ƒx)</b></ACRONYM></font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>6</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>7</font></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>8</font></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>9</font></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>10</font></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr></table></td></tr><tr><td bgcolor=f0f8ff align=center><font color=black size=1 face=verdana><b>XLtoHTML v1.1 / OfficeTürkiye - 2010©</b></font></td></tr></table>

kenevir47
23.03.2014, 01:19
ŞUBE SEÇERKEN.
<table border=1><tr><td align=left valign=center><font size=1 color=red face=verdana><b>Gönderen XL Ver.:</b></font><font size=1 face=verdana> bilinmiyor / </font><font size=1 color=red face=verdana><b>OS Ver.:</b></font><font size=1 face=verdana> </font></td></tr><tr valign=top><td><table border=0 bgcolor=d4d0c8 cellspacing=1 cellpadding=1 align=center><tr align=center valign=center bgcolor=white><td bgcolor=d4d0c8 align=center><font color=black size=2>+</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>J</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>K</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>L</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>M</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>N</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>O</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>P</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>Q</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>R</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>S</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>T</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>1</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>200</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>2</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>3</font></td><td bgcolor=yellow nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>4</font></td><td bgcolor=yellow></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>5</font></td><td bgcolor=yellow nowrap=true><font size=1 color=black face=verdana>ŞUBE</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white nowrap=true align=center><font size=1 color=black face=verdana><ACRONYM title='=" " $J$5="MERKEZ" DÜŞEYARA($J$3;Mükellef!$A$2:$H$6;4;0)&" " $J$5="MERKEZ" DÜŞEYARA($J$3;Mükellef!$A$2:$H$6;5;0)&" " $J$5="MERKEZ" DÜŞEYARA($J$3;Mükellef!$A$2:$H$6;6;0)&" NO: "&EĞER($J$5="MERKEZ";DÜŞEYARA($J$3;Mükellef!$A$2:$H$6;7;0)&"/") '> YANLIŞ Barbaros Mah. 50892.sokak NO. /51 B <b>(ƒx)</b></ACRONYM></font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>6</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>7</font></td><td bgcolor=white><b></b></td><td bgcolor=white><b></b></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr></table></td></tr><tr><td bgcolor=f0f8ff align=center><font color=black size=1 face=verdana><b>XLtoHTML v1.1 / OfficeTürkiye - 2010©</b></font></td></tr></table>

kenevir47
23.03.2014, 01:22
j5 Hücresine MERKEZ seçerken O 5 Hücresine Adresin sonuna YANLIŞ kelimesi geçiyor ve aynı şekilde J5 Hücresine ŞUBE seçerken bu sefer O5 Hücresine adresi Sol başına YANLIŞ kelime görünüyor

Formül.
=EĞER($J$5="MERKEZ";DÜŞEYARA($J$3;Mükellef!$A$2:$H$6;4;0)&" "&EĞER($J$5="MERKEZ";DÜŞEYARA($J$3;Mükellef!$A$2:$H$6;5;0)&" "&EĞER($J$5="MERKEZ";DÜŞEYARA($J$3;Mükellef!$A$2:$H$6;6;0)&" NO: "&EĞER($J$5="MERKEZ";DÜŞEYARA($J$3;Mükellef!$A$2:$H$6;7;0)&"/")&EĞER($J$5="MERKEZ";DÜŞEYARA($J$3;Mükellef!$A$2:$H$6;8;0)&" "&("SİLOPİ ŞIRNAK")))))&" "&EĞER($J$5="ŞUBE";DÜŞEYARA($J$3;Mükellef!$A$2:$FB$6;60;0)&" "&EĞER($J$5="ŞUBE";DÜŞEYARA($J$3;Mükellef!$A$2:$FB$6;61;0)&" ")&EĞER($J$5="ŞUBE";DÜŞEYARA($J$3;Mükellef!$A$2:$FB$6;62;0)&" NO.")&" "&EĞER($J$5="ŞUBE";DÜŞEYARA($J$3;Mükellef!$A$2:$FB$6;63;0)&"/"&EĞER($J$5="ŞUBE";DÜŞEYARA($J$3;Mükellef!$A$2:$FB$6;64;0)&" "&EĞER($J$5="ŞUBE";DÜŞEYARA($J$3;Mükellef!$A$2:$FB$6;65;0)))))

ataköylü-59
23.03.2014, 11:57
<table border=1><tr><td align=left valign=center><font size=1 color=red face=verdana><b>Gönderen XL Ver.:</b></font><font size=1 face=verdana> bilinmiyor / </font><font size=1 color=red face=verdana><b>OS Ver.:</b></font><font size=1 face=verdana> </font></td></tr><tr valign=top><td><table border=0 bgcolor=d4d0c8 cellspacing=1 cellpadding=1 align=center><tr align=center valign=center bgcolor=white><td bgcolor=d4d0c8 align=center><font color=black size=2>+</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>B</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>C</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>D</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>E</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>F</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>MAH.</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Cad.</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Kapı No.</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>İl/İlçe</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>2</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>CUMHURİYET 589</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>İPEKYOL CADDESİ</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>NO: </font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>355/E</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>SİLOPİ ŞIRNAK </font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>3</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BARBAROS MAH. </font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>50892.SOKAK </font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>NO. </font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>51/B</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>SİLOPİ ŞIRNAK</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>4</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>5</font></td><td bgcolor=yellow nowrap=true><font size=1 color=black face=verdana>ŞUBE</font></td><td bgcolor=white nowrap=true align=center><font size=1 color=black face=verdana><ACRONYM title='=B5="MERKEZ" DÜŞEYARA(B2;B2:F3;1;0)&" "&EĞER(B5="MERKEZ";DÜŞEYARA(B2;B2:F3;2;0)&" "&EĞER(B5="MERKEZ";DÜŞEYARA(B2;B2:F3;3;0)&" "&EĞER(B5="MERKEZ";DÜŞEYARA(B2;B2:F3;4;0)&" "&EĞER(B5="MERKEZ";DÜŞEYARA(B2;B2:F3;5;0))))) B5="ŞUBE" B3 '>BARBAROS MAH. 50892.SOKAK NO. 51/B SİLOPİ ŞIRNAK <b>(ƒx)</b></ACRONYM></font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>6</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true align=center><font size=1 color=black face=verdana><ACRONYM title='=B5="MERKEZ" DÜŞEYARA(B2;B2:F3;1;0)&" "&EĞER(B5="MERKEZ";DÜŞEYARA(B2;B2:F3;2;0)&" "&EĞER(B5="MERKEZ";DÜŞEYARA(B2;B2:F3;3;0)&" "&EĞER(B5="MERKEZ";DÜŞEYARA(B2;B2:F3;4;0)&" "&EĞER(B5="MERKEZ";DÜŞEYARA(B2;B2:F3;5;0))))) B5="ŞUBE" B3 '>BARBAROS MAH. 50892.SOKAK NO. 51/B SİLOPİ ŞIRNAK <b>(ƒx)</b></ACRONYM></font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr></table></td></tr><tr><td bgcolor=f0f8ff align=center><font color=black size=1 face=verdana><b>XLtoHTML v1.1 / OfficeTürkiye - 2010©</b></font></td></tr></table>

=EĞER(B5="MERKEZ";DÜŞEYARA(B2;B2:F3;1;0)&" "&EĞER(B5="MERKEZ";DÜŞEYARA(B2;B2:F3;2;0)&" "&EĞER(B5="MERKEZ";DÜŞEYARA(B2;B2:F3;3;0)&" "&EĞER(B5="MERKEZ";DÜŞEYARA(B2;B2:F3;4;0)&" "&EĞER(B5="MERKEZ";DÜŞEYARA(B2;B2:F3;5;0)))));EĞER(B5="ŞUBE";DÜŞEYARA(B3;B2:F3;1;0)&" "&EĞER(B5="ŞUBE";DÜŞEYARA(B3;B2:F3;2;0)&" "&EĞER(B5="ŞUBE";DÜŞEYARA(B3;B2:F3;3;0)&" "&EĞER(B5="ŞUBE";DÜŞEYARA(B3;B2:F3;4;0)&" "&(" SİLOPİ ŞIRNAK"))))))
Sayın kenevir47;
Kodu inceleyin ve kendinize uyarlayın sanırım o "yanlış" sözcüğünden kurtulursunuz. Burada benim yaptığım ilk SİLOPİ ŞIRNAK sözcüklerini hücre başvurusu ile yazdırdım. 1 nci toplu parantezlerin bittiği yerde ;EĞER( diye ŞUBE EĞER lerine başladım.

kenevir47
23.03.2014, 22:28
Sayın ataköylü-59;
Yapmış olduğum formülde örnek vereyim "Sözleşme sayfasında iken "o" veya "c" hücresinde Mükellef sayfasından hücre başvurusunu yapmışım sizin yazdığınız formül ise aynı sayfada iken yapılabilir başka sayfalardan bilgi almak mümkün olmuyor.

Formülü tek başına kullanmak istediğim zaman bir sorun yok ancak Ayraçların sonundan itibaren şube ile ilgili formülü girdiğimde "YANLIŞ" sözcüğü çıkıyor.
1. Formül =EĞER($J$5="MERKEZ";DÜŞEYARA($J$3;Mükellef!$A$2:$H$6;4;0)&" "&EĞER($J$5="MERKEZ";DÜŞEYARA($J$3;Mükellef!$A$2:$H$6;5;0)&" "&EĞER($J$5="MERKEZ";DÜŞEYARA($J$3;Mükellef!$A$2:$H$6;6;0)&" NO: "&EĞER($J$5="MERKEZ";DÜŞEYARA($J$3;Mükellef!$A$2:$H$6;7;0)&"/")&EĞER($J$5="MERKEZ";DÜŞEYARA($J$3;Mükellef!$A$2:$H$6;8;0)&" "&("SİLOPİ ŞIRNAK"))))) bu ayraçtan sonra gelen 2. Formül girdiğimde oluşuyor "YANLIŞ" SÖZCÜĞÜ

2. Formül Birinci formülün devamıdır &" "&EĞER($J$5="ŞUBE";DÜŞEYARA($J$3;Mükellef!$A$2:$FB$6;60;0)&" "&EĞER($J$5="ŞUBE";DÜŞEYARA($J$3;Mükellef!$A$2:$FB$6;61;0)&" ")&EĞER($J$5="ŞUBE";DÜŞEYARA($J$3;Mükellef!$A$2:$FB$6;62;0)&" NO.")&" "&EĞER($J$5="ŞUBE";DÜŞEYARA($J$3;Mükellef!$A$2:$FB$6;63;0)&"/"&EĞER($J$5="ŞUBE";DÜŞEYARA($J$3;Mükellef!$A$2:$FB$6;64;0)&" "&EĞER($J$5="ŞUBE";DÜŞEYARA($J$3;Mükellef!$A$2:$FB$6;65;0)))))

Yakup Karaman
24.03.2014, 07:13
Merhaba,
Formülü yanlış kurmuşsunuz. Aşağıdaki şekilde kullanın ve sonucu bildirin.

=EĞER($J$5="MERKEZ";DÜŞEYARA($J$3;Mükellef!$A:$H;4;0)&" "&DÜŞEYARA($J$3;Mükellef!$A:$H;5;0)&" "&DÜŞEYARA($J$3;Mükellef!$A:$H;6;0)&" NO: "&DÜŞEYARA($J$3;Mükellef!$A:$H;7;0)&"/"&DÜŞEYARA($J$3;Mükellef!$A:$H;8;0)&" "&"SİLOPİ ŞIRNAK";DÜŞEYARA($J$3;Mükellef!$A:$FB;60;0)&" "&DÜŞEYARA($J$3;Mükellef!$A:$FB;61;0)&" "&DÜŞEYARA($J$3;Mükellef!$A:$FB;62;0)&" NO. "&DÜŞEYARA($J$3;Mükellef!$A:$FB;63;0)&"/"&DÜŞEYARA($J$3;Mükellef!$A:$FB;64;0)&" "&DÜŞEYARA($J$3;Mükellef!$A:$FB;65;0))

kenevir47
24.03.2014, 12:21
Yakup bey teşekkür ederim.
sorun hal oldu. Kafamda bir soru işareti kaldı formülde "MERKEZ" geçiyor "ŞUBE" geçmiyor bu nasıl oluyor bana anlatabilirmisiniz.

Yakup Karaman
24.03.2014, 16:08
Formül diyor ki, ya "MERKEZ"dir ya da "MERKEZ"den başka bir şey.

kenevir47
24.03.2014, 16:57
Çok teşekkür ederim. Allah Razı olsun.

kenevir47
24.03.2014, 23:30
Yakup Bey Merhaba.
Tablomda "T" Sütununda TARİH, "Q" Sütununda sicil numarası var ben aşağıdaki formülü kullanarak tek hücrede hem tarih hem sicil no yazılmasını istiyorum
=EĞER($F$1;DÜŞEYARA($F$1;Mükellef!$A:$FE;20;0))&" - "&EĞER($F$1;DÜŞEYARA($F$1;Mükellef!A:FE;17;0))
formülü bu şekilde kullandığımda tarihi tarih ile alakası olmayan tarih veriyor ama sicil no düzgün veriyor ben metneçevir kullandım fakat başaramadım.
Teşekkür ederim.

Yakup Karaman
25.03.2014, 08:58
Her şeyden önce EĞER fonksiyonunun kullanımına dair biraz örnek incelemenizi tavsiye ederim.
Formülü aşağıdaki şekilde kullanın:

=EĞER(F1<>"";METNEÇEVİR(DÜŞEYARA(F1;Mükellef!$A:$T;20;0);"gg.aa.yyyy")&" - "&DÜŞEYARA(F1;Mükellef!$A:$T;17;0);"")

kenevir47
25.03.2014, 21:01
Teşekkür ederim. Yakup bey.