1. Tuyển Mod quản lý diễn đàn. Các thành viên xem chi tiết tại đây

Hỏi về excel: làm sao để biết format của từng ô

Chủ đề trong 'Hỏi gì đáp nấy' bởi newchance2, 13/01/2012.

  1. 1 người đang xem box này (Thành viên: 0, Khách: 1)
  1. newchance2

    newchance2 Thành viên mới

    Tham gia ngày:
    24/07/2008
    Bài viết:
    316
    Đã được thích:
    0
    Mọi người xem ảnh nhé. Rõ ràng 2 ô "Cần Thơ" giống hệt nhau (tớ đã copy format của 1 ô và paste sang ô kia rồi), nhưng sao công thức nó vẫn thể hiện là nội dung 2 ô đó khác nhau nhỉ. Chẳng là tớ đang dùng lệnh Vlookup nhưng nó chẳng ra, nghiên cứu 1 lúc thì hóa ra là 2 ô ko giống nhau nên nó ko nhận :(.
    Mọi người giúp tớ với.
    [​IMG]
    http://ttvnol.com/data:image/jpeg;base64,/9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0aHBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCAC6AZsDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEB***BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD1uyb/AEWP/rjF/I1M8mxGbrgZqlayYt046RRfyNPklzG4x1B711NanOnoSmeQPsEaltpYjfjAGM8kY7iq7XU8TKWaNhxuHmpySMnGOmDx3zT544pSfNjRwCSNyg0HSR/z4xf98rSGOjvfMjWQKNpOODyOcelWd9Z86i2UQlBGeCqjGOvtU4l4HH60WC7LO6sv+2lE8Nq237VJctDsH90AsWx6bR+Zqa5vPs9pNPs3eWjPjPXAzXm8+qzWuqXOvNPbPKsjQQmBDKJXCIdg9CQ2M47HrWkKTkiXNI9W3VTg1a1ubt7eEzOykguIH8vI4I8zG0kHjGeoI7U8y5BGP1rCVb2TRZtGksZFb7K0C3QdDE524Bxu3DPuvrz3qIxRSd3Y6G4u4rWLzZn2puVM4J5YhR09yKl3VxV9Y3WrCeS40c7RFbBIZ2iZnMcjMwGGIGVOBkjOe1dVHKBGoEewADCcfL7ccVTgkFy3uo3VW872/Wjzvb9aiwXLO6jdVbzvb9aPO9v1p2C5Z3Ubqred7frR53t+tFguWd1MVv8AVf7z/wDs1Q+d7frTUk/1PHd//Z6TC5YNzCCQZUBHUFhSfaof+e0f/fQpBf2+naUbu7k8uJXYcKWLEuQFVQCWYkgAAEkkACrdlfRahbCeBLhEYkAXFvJA/H+y6hh+VRcpJlX7VD/z2j/76FH2qH/ntH/30KsJqNtJcy28bu8sUohkCxsQjFA4ycYA2kc9MkDOeKks7yDULKC8tX8yCdBJG+CNykZBweaLrsNxaKf2qH/ntH/30KPtUP8Az2j/AO+hV4SgztFh8qoYkoduDno2ME8HgHI4z1FS0JrsJpmZ9qh/57R/99Cj7VD/AM9o/wDvoVp0U7rsFmZn2qH/AJ7R/wDfQo+1Q/8APaP/AL6FadFF12CzMz7TCekqf99Cl+0xf89U/wC+hWlRRcRmfaof+eyf99Cj7VD/AM9o/wDvoVE+pWek2N/e39wkFvFM7O7/AEHQdSfYcmrVxqtjbXdpazXKLcXjFYI+Sz4UseOwwDyePzo07DSdrkX2qH/ntH/30KPtUP8Az2T/AL6FadFGgWZm/aYv+eqf99ClWZHOFdWPsc1o1Rv22zQn/Zb/ANlpp3YmyI3cCkgzRgjggsKT7Zb/APPeP/vsVXtebK2ION0KNx7qDVC3123vhqKaeHubixkMTwhgpLD0JOMZyMn0NVyom7Nf7Zb/APPeP/vsUfbLf/nvH/32Ko6ZcXtzZxvf2b2lyGAeMyK4PTkFSePrz/M3Of7x/OnyIOZjvtlv/wA94/8AvsU9J45M+XIrY67TnFZOpX1/aT20dpp7XYmfYXE2wRnk5bg4XA68+mMkZtSNsvIT1LRyfoU/xpOCQKRbjb/V/wDXEf8AstIbuBSQZowRwQWFQRyf6vj/AJYD/wBlrD13VpNH8M297De2lq5EQH2oIRJuXJVd80S7v4uW6KeCaSSHd3Oi+2W//PeP/vsUfbLf/nvH/wB9ivLP+Fial/0E9I/K0/8AljXbeF9Wl1nSRdy31pcv5xU/ZQgEeMfK2yaVd3fhujDgUJJjdzd+2W//AD3j/wC+xR9st/8AnvH/AN9is/UNZ0zSfL/tHVLSy83Pl/abhY9+MZxuIzjI/MVS/wCEx8Mf9DLpH/gfF/8AFUWj1Emzd+2W/wDz3j/77FH2yD/nvH/32Kp29/a31kt5Z3UV1bNkrLDIHRsHBwRweQR+FBvoc9B+VcWLxaoNJ9Tqw+GdZOwtt/qF/wCuUX8jTn+430pLYfuF/wCuMX8jUjLlSB3Feg3qzjjsgk/j/GtSQZc8fp/9asZ3lIbMQAPU7v8A61aMt5Z7zm7tgfeVazsywurOK9G13lTIA+VR2z3I461mWjtJaROxyxUEn8K0FvbJWB+1234SrWfYD/QYf9wfyqoiZKQGBBAIPBBqO3tbe0i8q2gihjyTsjQKMnqcCp0WNrkpKrMvlM+AWHIZR/Dz3qirSW6XdyZo2gVnZIZGZXAUZIGRk8EdR174Ip3voLQuUVV03UrXVbP7TbOrKGKOAQdrDqDjj8uD1qO0vbm5PntawxWBUskrTnzCvYlNuAD1+90xkA8CrNC9C9RVBdc05raW4MzpHEVDmWF0I3HCnDAHBPfp19KfBq9jcY2SsCWZdskbIwKjJBDAEHBBweo5pa9QLlFJDIk8KTR5KOoZSQQcHkcHkU/FADaKdijFAxtFOxRigBtNT/lj9ZP/AGepMUxB/qP96T/2ekwC4hujYWV1aQ/aHtLh5TbggNKuHUhSSAG+bIyQOMZGcjA8X2Wq+JNLgWDQrqGZY5ni3izaWCcAeWSzs4VTzzH84IHK108F1JBEIxCjAEnO/HUk+nvUv9oS/wDPun/fw/4Vm4u9y7mD/Y+onXRdNB+7/tZLktvX/Viy8otjP9/jHXv05rBsfC2oR6FNbxaK9jd/2HLZ3DmWM/bpmRQnKsSdm1gC+MbsLxXef2hL/wA+6f8Afw/4Uf2hL/z7p/38P+FFmae1enyKGm6U1hr880dskNo1jBEm3ABdXlZuBzn5wc98/Wt6qH9oS/8APun/AH8P+FH9oS/8+6f9/D/hRZmbdy/RVD+0Jf8An3T/AL+H/Cj+0Jf+fdP+/h/wo5WFy/RVD+0Jf+fdP+/h/wAKP7Ql/wCfdP8Av4f8KOVhcv1nafoWnaXdXFxaW6xyTnLH+6P7q+gzzj+gADv7Ql7wJ/38/wDrUf2hJ/zwX/v5/wDWosw0MrWorq58M65bWVrLdXNwJoY4omRSSy7c5dlGBnJ5/Oo9Sk1KZ/Dsseh3reRc+dcIJbcGEeU6YOZcE5cH5SeAe+AdOC5lgMv7pG8yQv8AfIxnt0qb+0Jf+fdP+/h/woswUrK3r+Jfoqh/aEv/AD7p/wB/D/hR/aEv/Pun/fw/4UWYXG6hoWnapdW9xd26ySQHKn+8P7reozzj+hIK6j/rYfo39KX+0JP+eC/9/P8A61QzzNcOhZAoUEcNnOce3tTimmS7HO6rqK6R4YjujIiTG3ijh8xwoMhUBck8Yycn0ANcW0j+DfGWmTXaQWlpfwi0nAut5JXAErZC4525P+9616aiFYI4Xt4pBGoUEvjIAwONppz/ALzG+0ibHrJn/wBlq2mxJ2GqnzKeeo/nWF4qkk/s1NNtp3ivNRf7PEY3CyAYJdlyRyFBwfUiuh8yQYxbpwQf9b/9jR5kn/Pun/f3/wCxp30EjnfB+rtrvh22nldTeQ5gu1Vs7ZUO1vzIyPY1sspF9b/9c5f5x1Z8yT/n3T/v7/8AY0wqzzrIyKgVSoAbdnJHsPQUJ9waQR/8s/8Ar3H/ALJVJbJLzSIIJWmVHgiyYZnibhVPDIQw6djV6Mf6r/r3H/slEXmRQxxeSjbFChvMIyAMDjaaSAxP+EUsP+fjV/8Awb3f/wAdrTtbFLOGKCJpmRG4M0zytyc8s5LHr3NWvMk/590/7+//AGNHmSZH+jpwQf8AWn/4mnp0G2zm/Fdlqd1ZQLpwmfEmZI4CyyHg4O4XEGFHORk5JHHGa5P+xfE3/PtrH/gRJ/8ALSvUPMk/590/7+//AGNHmSf8+6f9/f8A7Gk1calYz9LtrpNJtIr1ibgRqHyCCPQHLyEsBgE72yQTnmrX9nn1UfVCT+eam8yTgiBMg5/1p/8Aiad9quP+eVt+M3/1q8vMMNOrKMlG514bE+yT1IrUfuV/64w/yNTYqO0H7lf+uEP8mqrrw/4p7Uv+vWX/ANBNep1OKGqRexTfLX+6K5N4JtFsjKgtNKN20ccaW0ypCpUMSzM8RAZhxwhJ2qM+lq01O5vJNIEt75TXloGMMBj37ypJdlZSdvHBHQ9QQeKcX0BSudF5af3RTgoAwBXEx393ZeGdIitdSgjDIyyXNzNHGsbqBiIny2HrwQD8vXNduoYou7G7HOOlJxsHUp31ibxAFuprc4KkxrG24Eg4IdWHUA9O1Y0sWrWFu9nZWt1cp5rOJhIke5SqcYSSMZBDfw+nvXTYoxSTswdmYXhu1vIIL5r62eB5rnequ6sSvloueGbup6nNTRaTcLbSWEl3HJpzRNEsZhIlCkYxv3YOBx93PT61qRyRylhHIj7ThtrA4PoafiiU3d3DY5260W+e0lZriO4u3a3RWji8tVSOQNnBY5PLE888YFJd6PdvCIywnubq5Ek9wiiNI02hCApYnlMgdeTk4FdHijFP2jHpaw0KAAAMAUYp2KMVNxbDcUYp2KMUXGNxRinYoxRcBuKjT/lh/vyf+z1NiokH+o/35P8A2ehgMEkj5KRptyQCzkE4OD0B7g0uZv7kX/fZ/wDiaZbyqsABBz5kv/oxq8hn8a67ZNru/XrqR9Pu0hgBtITGw890YSssY2/Kqkcrkk49nKVhJNnsJaYAnZF/32f/AImlJmBI2Rf99n/4moLW6ebT4JJ1VZniVnEZ3KGI5we4z3qy0y724PX0piGZm/uRf99n/wCJoLTAE7Iv++z/APE1z15d3mo+KRY6fq81tb2sAa9SKOJyGb7g+ZSVJGTzxgDFdC0y7TwenpSQCkzAkbIv++z/APE0mZv7kX/fZ/8AiaoeI7qWDQNRmtrp7WaGF5VmVVO3aN38QIwcYOR0Nczb6lqRvvCSNr87JqEDSzp5UH77avmcYTOMNt+XHAB65NK40jtczf3Iv++z/wDE0Zn7Rxk+nmH/AOJpfOX0P5VXsdS+1XckRsrqHyXCO0qqBu4OBgnPBByOMEeozWoibzi4j8pMmRd43HGBx9fUUuZv7kX/AH2f/iarWb4jsic82RP6x/40efbm4l8yVlYSDavmEdk7bvXHYdenOSAizmb+5F/32f8A4mjM39yL/vs//E1QS4t/s8JEzGU+XkeaT3TPG/8A3e5+9/FuObs115cTOkMspUZ2RgFm+gJGT7UximSRMF402lgCVckjJwOoHc0pdy7hEUhTtJZsc4B7A+oqpHfrfack6wTRLJJEUEoAJBkXnAJ4P/1+mKsxSBXuQQf9f/7TSizEhr3BjlSJ2t1kf7iGUgt9Bt5qTM39yL/vs/8AxNZV9Yy6lpsmqWxV90kSrF52zakchZiSOjdRt6jv83Ap2Piff4gOlMPPiYsIbgLgttz97sSMEEjjI7cgC97Yb0OhzN/ci/7+H/4mjM3PyRcf7Z/+Jqtdan9mmhiFldTec21GiVSN3XByRjgE5PGAfQ4tiZfmOD27fWiwrkbyyRoXcQqqjJZpCAP/AB2nZm/uRf8AfZ/+JrC8TXcM8KaY0skYnVnkZI2chQPl4UE/eK/gDTfB2uHU9FEVyWN5aN5E4YfNkdCc89P1Bp8mlwTVzfzN/ci/77P/AMTQrt5ojdFBKkgq2RxjPYeoqve6mtlEsn2W5nVmCfuUDEEnA4znk8fXA7ipRJ5l5b/IUJikJU445j44yPyqRkkX/LH/AK9x/wCyU1JJZEV1jQKw3Dc5zg9Ogp8I/wBR/wBew/8AZK5PxffC18Lae/2k2xLQjf8AaPJz+6Jxu+0QZ+m8/wC6eom4bux1WZv7kX/fZ/8AiaMzZHyRcnH3z/8AE15BZav599bxf2jPcb5FXyYNWIkkycbVP9qH5j0HB57GvTtB2Q2ez7FqVpmbOzULv7RIenIbzJML7ZHIPHOSRlcpo0czf3Iv++z/APE0Zm/uRf8AfZ/+JrmvGtwselpcbb1PLz/pMV55EUOWUfvB9og3Z6D5jg/XB89/t0f9Bk/+DY//AC2ocrMFG57PmbI+SLk4++f/AImjM39yL/vs/wDxNVNJZY9Ot0+z3kGCf3V3P50q/MfvPvfPqPmOBgcdBdFwgHQH/tjn+tUT1CzH7pf+uEP8mqxioLIfuk/694f5NVnFT1FH4UNxVdL6zkuPs6XcDTgkeWJAWyOoxnParWKiW0gS7kulhQXEihHkA+ZlHQf59B6DCK1H4oxTsUYoQupGxIZVG0FjgFzgZ+tY/iOR9MsJZZJncsuC0RK+Wfpnp7/yzkbbxrIjI4yrDBFc5c+Grq+1FEvbwS6VGM+VyJJD2Vj0K+vc8A988lZV/aJx2Nqbha0iDwLYiPRTqLySvcXzb3L8ABSQoUemOc980uj6lfJo39oXv26VpI4/LE/kLG7uQBs8sbgCSPvDgV1QUAAAAAcACqw062GnCwEX+jBPLCbjwvbnr+Oc12qXczZmHWrldsDWUX2z7V9meMTnYCYzIGD7ckYx/CO/41p/ElzF9oK6cjJEJ2Um4xuWFtr8beOCCPXkHHU7EOkWdukSpG5McpmVnld2L4K5LMSW4OOSeMegpH0awdXVoMh1lVvnbkSnL9+5/Ltii8RK3UoT668erx2MVukqy/Kkgd8CTYWCufLKrwP7xbkHbUdtqF+/ghtRnKJeCzaUOh3ZIQkNjaBn2xj61pf2JY/blvPKfzlcOv719obbt3Bc7c7eM4qSPS7SLTnsFjb7K6shjaRj8p6gEnIHsOnai8bWFHe7MCDVr21tppd1xeRHyxD9tgeCR3IJcKqRbmAAU8J/e5wOLH/CRZh+1RW8kivbW0qRFwvMshXHTr9Tjjtya2bvTre9jiSZXxE25DHKyEHBHVSD0JGO9QpomnxxJElvhESONQHbhY23IOvY/wD16fNAFoZMur6o11awJa28Uq332e4X7QWVgYi42tsz0OegOVx0OakbxIwn1EJYytBaRysJdrgO0fVSSm0c5Awx6dBWrLpVnM7O8TB2lWYssjKd4UKCCDxwMYHBHXrTW0ayaS6YpJi6RkmQTOEYMME7M7QT6gZ96OaJRPbPLLbpJNGsbsMlFfcB6c4Hb/JpsY/49/8ArpL/AOz1ZVQqhQOAMCoI/wDl3/66y/8AtSpZK0IIIj5P/bSX/wBGNXGL8K9O23ySatq8sWoSrLeRs8IE7K5cZIjBHzMTwR19hXe/Z0ySDIuTkhJGUZ+gNHkD/npN/wB/n/xodnuCbRUhs47W0jt4ECRRIERR0VQMAflUlxbtIkqLI8TMCBIgG5Se4yCMj3BFT+QD/HN/3+f/ABo8gf8APSb/AL/P/jVXEYGi+F10S7u7iPUb65a7cyTC5MZDOcfNlUBGAMAZwB2rYaI7T9Kn8gf89Jv+/wA/+NHkA/xzf9/n/wAaExmdrNlLd6Xd20VtDcmZDGYZ5jEjq3DAsFYjgnsfw61yWkeEtWsdT0u4ureG4i05TDaiTUy/2aNgFbYq2qbjtGPmbt1HWu+8gf8APSb/AL/P/jR5A/56Tf8Af5/8aQ0yHyjTljO5c54PFSeQP+ek3/f5/wDGg26kEF5iD285/wDGjmFYoWsR8uxHpZkfrH/hTlSRJZP3UjKzjBBGAMKO7fU8AdDxnGbzQIwX5SuzhShKke3FJ5A/56Tf9/n/AMaOYSRnLFMbeKMwyhhsyxI7Fc/x57nueh68Zt+Uam8gf89Jv+/z/wCNHkD/AJ6Tf9/n/wAaExlW5jJiBOSTLGST/wBdFNMdXX7Syjk3A52lsArGCcDk4FXfs6ZBJkbByA8jMM/QmlMClyw3qx67HK5+uDQ5XBGHdaRDctKRqVzAs2PNSG0kUSEY5PocDGRg4PsMOh0q1g1GG5twGcRC2Ci1eNY4xkjGeBzgVs+QP+ek3/f5/wDGjyB/z0m/7/P/AI1MU11G3foReWRnGeetVr8z2+mXk1tF5s8cLPHHtLbmCkgYHJyfSr3kAf8ALSb/AL/P/jR5A/vzf9/n/wAapu6sODUZKTWx5Qmu+LI9QkvRoMvnSIEbNtOVwDkfLux6/mfWk8P3Gv2viBZ10KaP7bMq3UjRXBG0sMsdzEDAJwT0+leseQP+ek3/AH+f/GjyB/z0m/7/AD/41zKlUT+NnsSzKg4tKgtSIRkdMioxHi+hPpFJ/NP8Ks+QP+ek3/f5/wDGlWFUff8AMWxjLMWOPxrpvoeKQwj/AI9/+vb/AOIrG1LR7nVNEs7e1u/sjosbF8zDICYx+6ljbv3Yjjp0I24P+Xb/AK9v/iKeLZFGFMijsFlYAfQA0kHW5xUPgvUlnjM+tu8IYF0Sa/VmXPIBN4cHHfB+hrprLTIdPj8qF7l1MgYm4uZJ2zwPvSMxA46Zx+dX/IH/AD0m/wC/z/40eQP783/f5/8AGmrLYbbMbWdFbVbULFdTW1wn+rkWedEGSM7likjLcDjJ4z9Qee/4QjV/+g//AOP6h/8AJtd15A/56Tf9/n/xo8gf89Jv+/z/AONGgJtFO1so7OGKCJpmRG4M0zyvyc8s5LHr3NTiJu2z8cf4ipfIH9+b/v8AP/jR5A/56Tf9/n/xp3EVoXaOOLacZtov5NUnnyf3v0FRJ/q7f/r2i/rS5qkiE9CTz5P736Cjz5P736Co80ZosguyTz5P736Co5777NEZZZNqDA+7kknoABySfQUZqrfRysIJYU8xoZN5jyAXGCCBnjPORn0o5UF2SrqyOFw0oLKzBWgZWIXGeCM9x9as+fJ/e/QVh38N1frvW1kjP2aePZIyZ3MF29GI5we9VPsjzancBLXMqXEJFxuH7oBELDrnkccDnPNWoJg5O1zpIr3z1Zo5NwVih+XHIOD+op/nyf3v0Fc9bafMmpLJ9j8t1uJZGudyndGS2E4Oe4OMY4z1psFjdw+Y0dmqzCCRZXfaRdOSME4PPQ/ex97FLkQuY6Pz5P736CmSXvlNGryYMjbE+XqcE/yBrnLTSZgiRSWzC3F2JBHJ5YwnlkHKp8v3uwqYWM39qRytZZdbppGuty/NGVYKOu7jIGMdqORBzaXOg8+T+9+go8+T+9+gqPNGamxVyTz5P736Cjz5P736Co80ZosFyTz5P736Co576aFo0RHleRiqqu0dFLHliB0U96M0hUGWKTvGSR+Ksv8AJjSC5IlxcMv7xDEfQsjf+gkilDMLa2cHnzZOf++6o2Nm1l9oL3TztMUwpj2rEq7sKvzHj5uB2xV4j/QLY/8ATZ//AGepBMPPk/vfoKPPk/vfoKjzRmq5UFyTz5P736Cjz5P736Co80Zp2QXJPPk/vfoKPPk/vfoKjzRmiyC5J58n979BR58n979BUeaM0WQXJPPk/vfoKrTaskFyLdmlMpUNiOBnwCcAkqCB0PWpc1nyWJm1hriTzRGIUVSkzICwZiQQpGeo68U4xQrs1PPk/vfoKZLeGCF5pJNqIpZjtzgDrWLHZTLqol+zYcTO73eV+eMg4Tru4yvBGPlzVUaG4sI4ltYxI9lJHNkg7n+Xbn1wQcHtT5EF3ex04uHYAh+DyOBR58n979BVWzQR2cSLB5AVQPKwBt9uCR+VTZpNJOwKTauSefJ/e/QUefJ/e/QVHmjNKyHck8+T+9+go8+T+9+gqPNGaLILknnyf3v0FHnyf3v0FR5ozRZBck8+T+9+go8+T+9+gqPNGaLILiS306SrGkTyuyM+FKKAAQCSWIHVhUizzPGN4KN3UlTj8VJH61BJEHLt8pZomiw67lwxU8jv90frUdnbGztjE13LdSPK0rSyrgnIUY6nP3amwXLm5o47MqcE2+P/AECjz5P736CiUYhsf+vf+iVHmiKutQbJPPk/vfoKPPk/vfoKjzRmqsguSefJ/e/QUefJ/e/QVHmjNFkFyTz5P736Cjz5P736Co80ZosguZw1q0WGKJxay+Uu1XF1sOPwo/tux/542/8A4HGuq0L/AJF/Tf8Ar1i/9AFaFc/tV2NFS03OF/tux/542/8A4HGj+27H/njb/wDgca7yil7Rdg9j5nB/23Y/88bf/wADjR/bdj/zxt//AAONd5RT9quwex8zg/7bsf8Anjb/APgcaP7bsf8Anjb/APgca7yij2q7B7HzOD/tux/542//AIHGj+27H/njb/8Agca6GPxFpc2pGyilmd95jMgtpfJ3jgr523y9wIIxuzkEdRijTvEenalfNZ20svnKhkCy20sQkQHBeMuoEi5I+ZSRyPUUe1XYPY+Zz39t2P8Azxt//A40f23Y/wDPG3/8DjXeUUe1XYfsfM4P+27H/njb/wDgcaP7bsf+eNv/AOBxrvKKXtF2F7HzOD/tux/542//AIHGj+27H/njb/8Agca7yij2i7B7HzOD/tux/wCeNv8A+Bxo/tux/wCeNv8A+BxrvKKftV2D2PmcH/bdj/zxt/8AwONSt4jtWgEJhtPLGMKLoDH04rt6jdljRncgKoJJPYUe0T6B7G3U4f8Atux/542//gcaP7bsf+eNv/4HGtmNo7sfbr0bkPzRQv8AdjXsSO7d8npnAq9a6pb3CEW8isEOCBxj8Kq/kT7PzOY/tux/542//gcaP7bsf+eNv/4HGuv+1e9H2r3pc3kP2Xmch/bdj/zxt/8AwONH9t2P/PG3/wDA411/2r3o+1e9HN5B7LzOQ/tux/542/8A4HGj+27H/njb/wDgca6/7V70favejm8g9l5nIf23Y/8APG3/APA40f23Y/8APG3/APA41ra54otdFjjVpIWuZnVI4pJgg5ONzHnCjBycVoWN9cTWUUl5bi3uCPniEgcKc+o60+fyD2Xmcz/bdj/zxt//AAONH9t2P/PG3/8AA4109nJ5uuXrf9O0A/8AHpa1KTqJdBqlfqcJ/bdj/wA8bf8A8DjR/bdj/wA8bf8A8DjXQar4k03RrgQXjXe/yjMRBZTThUBxuYxowUcHrik1DxLpemeW1xc***Igk82OCSWNEPR3dFKxqf7zEDAJ7Gp9qn0D2PmYH9t2P/PG3/8AA40f23Y/88bf/wADjXd9qzJdWsYdYi0ySf8A0yWIypEEPKjPfGAeDgE5O046Gj2i7B7HzOX/ALbsf+eNv/4HGj+27H/njb/+BxrornxDptpqkenzzSpM7rGH+zyGEO33UaULsVjkYUsCcjjkZ2aPaLsHsfM4T+27H/njb/8AgcaP7bsf+eNv/wCBxrvMUUe0XYPY+Zwf9t2P/PG3/wDA40f23Y/88bf/AMDjXeUUe0XYPY+Zwf8Abdj/AM8bf/wONJ/bVgesFuR6G+JFd7RT9quwex8ziJvEdrOqrJFaEL93F0Bj6YFRf23Y/wDPG3/8DjXeUUvaLsHsfM4P+27H/njb/wDgcaP7bsf+eNv/AOBxrvKKPaLsHsfM4P8Atux/542//gcaP7bsf+eNv/4HGu8oo9ouwex8zg/7bsf+eNv/AOBxo/tux/542/8A4HGu8oo9ouwex8zN0L/kX9N/69Yv/QBWhXOaTe38Wj2SrbWZUW0e0tcuCRtGMgRnH5mrv9pah/z62X/gW/8A8aqHB3LUlY2KKx/7Sv8A/n1sv/At/wD41R/aWof8+tl/4Fv/APGqORlc6Niisf8AtLUf+fSy/wDAt/8A41R/aWo/8+ll/wCBb/8AxqlyyDnibFRuCyMoOCQQD6Vl/wBpaj/z6WX/AIFv/wDGqP7S1H/n0sv/AALf/wCNUcsg54mP4Wvjp2k6boNxYajHf2kC28xFlJ5JKLgusu3yypxuADZ5xjORUeiarHrXiP7fcWeqW0scTwWkNzp1xCEjJBdndkCbmKLgZ4A9Sa3P7S1D/n0sv/At/wD41R/aWof8+tl/4Fv/APGqOV3uJzizYorH/tLUP+fWy/8AAt//AI1R/aWo/wDPpZf+Bb//ABqjlkHPE2KKx/7S1H/n0sv/AALf/wCNUf2lqP8Az6WX/gW//wAao5ZD54mxRWP/AGlqH/PpZf8AgW//AMao/tLUP+fSy/8AAt//AI1T5JBzxNiisf8AtLUf+fSy/wDAt/8A41R/aWo/8+ll/wCBb/8AxqlyyDnicx4t8Carr+u2V/pnivWNJgLhb+3gvJFV0A4aIA4RzgKeMc7sZBD9bNZY0iWxhaT/AI9zChkkZ2+7gZZiST7kknvUP9pah/z6WX/gW/8A8apP7R1D/n1sv/At/wD41Qoy3E5pmTbXsU0K+YCFK4I7qfT8DUMMcVtdvNE3DLinXunXk9wZ7dLO3d+ZF+0OysfXHljB/wA4qL+y9T9bL/v6/wD8brpXI9WYttaF37X70fa/eqX9mal/05f9/pP/AI3R/Zmpf9OX/f6T/wCN1fui94u/a/ej7X71S/szUv8Apy/7/Sf/ABuj+zNS/wCnL/v9J/8AG6PdD3i79r96PtfvVL+y9S/6cv8Av8//AMbo/svUvWy/7/P/APG6Pd7iuzI1C8bU9ftWtlkkj09JWcooyJG+QAbsDIwW544+lXNDn1YeadVkk3qSqDKFGXP3uOd31wOelWv7M1L/AKcv+/0n/wAbpf7M1L/py/7/AEn/AMbpe6PmZsaHJ5urXzf9MIR/49LUfiXTL/UXtjZW3nKgbd/xO7nT8Zxj/UKd/T+Lp26mq2mQ6jps9xKUspfOVFx9okXG0t/0zP8Ae/StX+0r/wD59LL/AMC3/wDjVc9Re9obQklHU43U7W5s76GO7uNb05G04ws2lxS6lvbexKtM8Dv0OcnaeevFT3uozf2Fpvh/UtKv7cXNhGNQazsLieOJMbWhQxK+GOCOvyjnJOK6v+0tQ/59LL/wLf8A+NUf2lqH/PpZf+Bb/wDxqoUJIrniYV7pGpXeqG8t7Fmt3KMjN4jvrU4wOtuibF/3c89+SazbyPxLLJe63Fo0LrFercQbrh1u/IhyhRYfKwS6+aQC4z5vbpXX/wBpah/z62X/AIFv/wDGqP7S1H/n0sv/AALf/wCNUcshKcTD1nV0vdch0q5stTSyt5Yp5JY9NuZFnkBDoquiFQqsFLEnqMY647MVkf2lqP8Az6WX/gW//wAao/tLUP8An1sv/At//jVHLIOeJsUVj/2lqP8Az6WX/gW//wAao/tLUf8An0sv/At//jVHLIfPE2KKx/7S1H/n0sv/AALf/wCNUf2lqP8Az6WX/gW//wAao5ZBzxNiisf+0tQ/59bL/wAC3/8AjVH9paj/AM+ll/4Fv/8AGqOWQueJsUVj/wBpaj/z6WX/AIFv/wDGqP7S1H/n0sv/AALf/wCNUcsh88TYorH/ALS1H/n0sv8AwLf/AONUf2lqP/PpZf8AgW//AMao5ZBzxNiisf8AtLUf+fSy/wDAt/8A41R/aWo/8+ll/wCBb/8AxqjlkHPE2KKx/wC0tQ/59bL/AMC3/wDjVH9paj/z6WX/AIFv/wDGqOWQueJyhsbBVQfYLckopJKnkkA+tJ9jsP8AoH235H/Gp3/g/wCuaf8AoIqS2t2uJMZwo6t6V6GijdnJZt6Fb7BZbC/9nW+0HBO09fzre0rStLbToy+nWjtuYZaFSfvHuRUWo+XHp8cMQwquD+hqxpsm2xQf7T/+hGsJu8Lm0I2kWv7J0n/oGWX/AIDp/hR/ZOk/9Ayy/wDAdP8ACjzaPNrKxpdB/ZOk/wDQMsv/AAHT/CoFsdBe5e2Wz01p41DPEIkLKD0JGMgHBqZ7hY42d2CqoJJPYCuJsdRuYr+01mbTbqFLu4YTXDmPYYpMLFwHLDG2Lqoxk9KXWw20jt/7J0n/AKBll/4Dp/hR/ZOk/wDQMsv/AAHT/CjzaPNp2FdB/ZOk/wDQMsv/AAHT/Cq9xpWlCa1A02zAMpBAgXkbG9vpVjzagnlzNbe0p/8AQGoSDQn/ALJ0n/oGWX/gOn+FH9k6T/0DLL/wHT/CjzaPNosF0H9k6T/0DLL/AMB0/wAKo3reFdNkWO+XRrV3GVWcRIWHqAavebXIeIb0Q+IJUbVtP09ZtO2Fr1NwcFm4X515/P6VL0Hodd/ZOkf9Ayx/8B0/wpf7J0n/AKBll/4Dp/hVDQ5y+g6eTC8H+jp+6cksnyjgkgH9Kv8Am1VtbCTurh/ZOk/9Ayy/8B0/wrP1TTNMRbbZp9ouZsHbAoyNje30rQ82qGqSZW2/67f+yNXNim40m0bUFeoVP7P07/nxtf8Avyv+FH9n6d/z42v/AH5X/CjzKPMrwfrM+7PR9lEP7P07/nxtf+/K/wCFQXaaJYRCW8i0+3jJ2h5lRAT6ZNT+ZWJc3tvYeI2uNQmihhe1VLeaVtqhtzF13HgEjYcd8e1VDETfV/eJ04o2Y7LS5Y1kjs7N0cBlZYlIIPQg4p39n6d/z42v/flf8Kitp4JLdHttvksNylRgEHuPr196l8yk8TPuxqlEP7P07/nxtf8Avyv+FLFp2nG+tVNhalTIQR5K4PyN7UnmU6GT/T7U+jn/ANAaro4icqkVcU6UeV6Gx/ZOk/8AQMsv/AdP8KP7J0n/AKBll/4Dp/hR5tHm19HZnk6B/ZOk/wDQMsv/AAHT/Cs+d***reCzuP7FhumIAhkESuSenynnmtDza5h9U0q31jXLXUri2/f+WBbSMC0wMYGFTq2emADmpd0NpHT/ANk6T/0DLL/wHT/Cj+ydJ/6Bll/4Dp/hWdoP2iDw/p8V3uFwluiuHOWBx0PvWj5tU1Z2FdB/ZOk/9Ayy/wDAdP8ACq9xpWlCa1A02zAMpBAgXkbG9vpVjzagnlzNbe0p/wDQGoSDQn/snSf+gZZf+A6f4Uf2TpP/AEDLL/wHT/CjzaPNosF0H9k6T/0DLL/wHT/CqN63hXTZFjv10a1dhlVnESEj1ANXvNrmNW1P7D4m3f2vpun77NRm+TcH+dvu/vE/rU9bBdWudKul6O6hl02xZWGQRAhBH5U7+ydJ/wCgZZf+A6f4Uizh0VlYMpGQQeDS+bVWC6D+ydJ/6Bll/wCA6f4VXuNK0oTWoGm2YBlIIEC8jY3t9KsebUE8uZrb2lP/AKA1CQaE/wDZOk/9Ayy/8B0/wo/snSf+gZZf+A6f4UebR5tKwXQf2TpP/QMsv/AdP8KpXp8LaY6Jfro1qzjKicRIWHtnrV3zawrw3z+Jl+w3NtAws/mM9u0oI39sOuP1pdUgurXNwaVo7KGXTbEgjIIgTn9KX+ydJ/6Bll/4Dp/hR5vvR5tVYLoP7J0n/oGWX/gOn+FNOk6ODzpVl/34X/CnebTTcYJFFg0Mk6TdELnychQvDnsMf3acumXijCugHoJT/wDE1s1lzXt5Fr9paFIBaTrIQQSXJUKc9gvJIxznrkdK09rLYj2cURNpl44wzoR7yn/4mrFjZ3jWwKCDbvccyEdGIP8ADWjU2m/8eX/bWX/0NqmdR2KUFcp/YL/+5bf9/W/+Jo+wX/8Actv+/rf/ABNbVFZczL5TE+wX/wDdtv8Av63/AMTS/YL/APuW3/f1v/ia2qKfOw5TF+wX/wDctv8Av63/AMTR9gv/AO5bf9/W/wDia2qKXMw5TF/s+/8A7tt/39b/AOJqGXT77zIci3zvOP3rf3T/ALNdBUEv+sg/3z/6C1Ckw5UZn2C//uW3/f1v/iaPsF//AHLb/v63/wATW1RRzMOUxfsF/wD3Lb/v63/xNH2C/wD7lt/39b/4mtqilzMOUxPsF/8A3bb/AL+t/wDE0fYL/wDu23/f1v8A4mtuinzMOUxPsF//AHbb/v63/wATVW702/l8kf6MD5mR+8b+6f8AZrpagl/1kH++f/QWqKqVWPLLYuDcXdHOf2JqP923/wC/rf8AxNH9iaj/AHbf/v63/wATXVUVw/2dROj63UOW/sTUfS3/AO/rf/E0f2JqPpb/APf1v/ia6mil/ZtFbXD61UOV/sTUfS3/AO/rf/E0f2JqP923/wC/rf8AxNdVRT/s6j5h9bqHK/2LqPpbf9/W/wDiaRdJv4rqBz9n4Y4Akb+6f9murqCX/WQf75/9BanDAUoNSW6JeIqNNdzL+wX/APctv+/rf/E0v2C//uW3/f1v/ia2qK9DmZzcpi/2ff8A9y2/7+t/8TR/Z9//AHLb/v63/wATW1RRzMfKjF+wX/8Actv+/rf/ABNH2C//ALlt/wB/W/8Aia2qKOZi5TF/s+//ALtt/wB/W/8Aiahl0++8yHIt87zj96390/7NdBUEv+sg/wB8/wDoLUKTDlRmfYL/APuW3/f1v/iaPsF//ctv+/rf/E1tUUczDlMX7Bf/ANy2/wC/rf8AxNH2C/8A7tt/39b/AOJraopczDlMX7Bf/wBy2/7+t/8AE0fYL/8AuW3/AH9b/wCJraop8zDlMX+z7/8Au23/AH9b/wCJqGXT77zIci3zvOP3rf3T/s10FQS/6yD/AHz/AOgtQpMOVGZ9gv8A+5bf9/W/+Jo+wX/9y2/7+t/8TW1RS5mHKYn2C/8A7lt/39b/AOJo+wX/APctv+/rf/E1t0UXYcpi/YL/APuW3/f1v/iaPsF//ctv+/rf/E1tUU+ZhymL/Z9//dtv+/rf/E0w6fqGelv/AN/W/wDia3aQdKFJhyozKyLzTdSuNZtr2G/tY4rfcFie0ZmIYANlhIPTjjj3pv2K1/594v8AvgVWeTSI71LN5LJbpxlYGKB2HsvU9DXmf2k39k7fqi7nRVNpv/Hl/wBtZf8A0NqwPsVtgf6PD/3wK1tFghOmJmGM/vJB90f32rahjPbS5bWMqmH9mua5r0Vyc+r3KyT3Fnocd3pdtK0U0qS5ncqcOYoQh3hTkHLKxKtgHjcapqNha+K9J08yWq3Eitvi+3RxOQ3C/uDzJkgnIwV2nBOSD1mHqdZRWNBqOjz3/wBhivNPkvNrH7OkqGTCsVY7Qc4BBB9CCKoeIb7UNK8qSz0bTrq2eSKEtNeNCweSQIPlELjblgc5z149QaudRRXK22u28V+1hrkOm6dcCOEpi6DpI8rSBUQuiEtiPOMZ56cZOpNe6PBqMOmzXdjHfTLvitXkQSyLzyqHkjg9B2NOwWZrVBL/AKyD/fP/AKC1RQiyuoEngWCWKRQySRgMrA9CCOopZLeASRAQxjL4Pyjn5TSAt0Vjapcx6fFF5VlHcXVxIIbeD5U3uQTyx6KAGYnBOAcAnANa1vzHbXp1vTYdPezTzJZFl327RkE7llZUHGCCCAV+hBIB0VFcjoGsaS3hmG7urmwihXehlfUI7lPlBYjzv48KDknn5TnOMnaDQXWnfa9NSzu1kj3wMHHlyccfOobg+oB+hoBampRXCt4g1eG31m4uvD+kpDpQfz/K1F3ZmWESgKDAAQdyjJIxzwcc9DBqGj3EFzNFdWEkVozLcukiMsDKMsHI+6R3zjFNobTRs1jatrek6O9sdS1SysfMdihurhItwC4ONxGcbl/MetPtL3SL+O3ksrmxuVnVmiaCRHEgUgMVI6gEgHHTNeY/GCwt7nxZ4FsZot1tdXjQzRoSm5GmtlIyuCOCRkc80hHof/Cd+EP+hr0P/wAGMP8A8VR/wnfhD/oa9D/8GMP/AMVWJ/wpzwH/ANAWT/wPuf8A45VO/wDhj8N9Ktjc39jHaWykAy3GpzxoCegy0oFJuwHT/wDCd+EP+hr0P/wYw/8AxVH/AAnfhD/oa9D/APBjD/8AFVykfw5+GM2ltqsUFvJp65LXaatMYgAcEl/NxwferLfCbwAnlg6UVEpCpnULgbzjOB+854BouB0X/Cd+EP8Aoa9D/wDBjD/8VR/wnfhD/oa9D/8ABjD/APFVyl78N/hlp1xbwX9vBazXLbYI59VmRpTkDCgy5Y5I6eoqK78A/CqwvlsbwWVvenaFt5tYlSQ56YUy557UXA7D/hO/CH/Q16H/AODGH/4qmf8ACYeGby7toLXxFpNxM8oVI4r6JmYkEAABskkkAe5FZH/Cm/Af/QFk/wDA+5/+OVwfjTwfofhTx14FXRbN7ZbvUlE4aeSUPtntwPvscffbp60XA93oqH7NB/zwj/74FH2aD/nhH/3wKYE1FQ/ZoP8AnhH/AN8Cj7NB/wA8I/8AvgUATUVD9mg/54R/98Cj7NB/zwj/AO+BQBNUEv8ArIP98/8AoLU77NB/zwj/AO+BUMlvAJIgIYxl8H5Rz8poAt0VD9mg/wCeEf8A3wKPs0H/ADwj/wC+BQBNRUP2aD/nhH/3wKPs0H/PCP8A74FAE1FQ/ZoP+eEf/fAo+zQf88I/++BQBNUEv+sg/wB8/wDoLU77NB/zwj/74FQyW8AkiAhjGXwflHPymgC3RUP2aD/nhH/3wKPs0H/PCP8A74FAE1FQ/ZoP+eEf/fAo+zQf88I/++BQBNRUP2aD/nhH/wB8Cj7NB/zwj/74FAE1IOlR/ZoP+eEf/fAqNra23c20ZPrtFAGDiua1bU9Km1NdKe8s7d454ri5eSVUOVIZVGfvMcL9B3zium+z33/PO3/7+n/4mj7Pff8APO3/AO/p/wDia8OFCrF35T0nOLW6DPFaeif8gwf9dJf/AEY1Zn2a9/552/8A39P/AMTWhpAnTTwNkZ/eSZ/eH++3tXThKNSFRuS0McROLhozHRtc0lLnTtP0lroyTyS21680YgjEjlz5q7hJlSzcKrZAX5gSduXrmk65f63MsVrNHa/bbWcND9mWCdI2iZmlLAzGUbWAxhdqrz1z3m64/wCecf8A38P/AMTRuuP+ecf/AH8P/wATXprQ41psclZ6FdwSaSxtlDQ6zeXcp3L8scguArdech04HPPPQ1seIrSe906KKCPe63trKRkDCpOjMefRVJrV3XH/ADzj/wC/h/8AiaN1x/zzj/7+H/4mq5ne5XNrc5HXdBub6bxHLDaLI93oyWdsxZQXfMxZOTwPmTrgflUWo6RfXF5qen/2Y8sGpXlvci/SdUWFUWIEMdwkDjyyVKA8svzLyR2e64/55x/9/D/8TRuuP+ecf/fw/wDxNJu4m7ixxrDEsaDCKAoHXimy/wCsg/3z/wCgtS7rj/nnH/38P/xNRyNN5kOY4/v8fOf7p9qRJna3a3TmyvbOD7RPYT+cLcOEMylGRlBPAbDEjJAJABIBJGZfS69qWkXzLowgU***e1naGS4IDgySfeaEMBygJI3KCx5wOo3XH/POP/v4f/iaN1x/zzj/AO/h/wDiaB3OE0nw/qy6lb3d7BPIG1f7az3TwGUJ9jMYLiIKm4PgYUHscnk103hu0lsdLlhmjEbG8upQoIPyvO7qePUMD+Nau64/55x/9/D/APE0brj/AJ5x/wDfw/8AxNU5Nqw27qzOV1DRr6fSfGFukGZL8v8AZV3r+8zbRoO/HzKRzjp6VFq2gXcl3qElpZI8Ig07yosqol+zzvI0Y54O0gDOBkjnGcdfuuP+ecf/AH8P/wATRuuP+ecf/fw//E0rjcmzB0KxlGoanq9zYS2M17KpW3kmDMqqiruZUYxhiV6gklQuTxgcR8WP+R++HH/YS/8Aa9rXqm64/wCecf8A38P/AMTXmXxS0DxJrGr+GdS0HTUuZ9MnkmCmVAu8PC6htzJkHyz0PY8jjKZJ6mK53xQt08GnrZzQwzm+i2PNEZUU89VDKT/30K4f/hIPjX/0KOj/APfSf/JVH/CQfGv/AKFHR/8AvpP/AJKqZRuB02vXV8DpOk3Nm2sXLyG6vI7GFYQYozlSBLLhfnMfBck4bA9M601eG10PTY9Vb+zv7L1MWs/22VF8pBGxiLuGK5MbR8hiMnrmsr/hIPjX/wBCjo//AH0n/wAlUf8ACQfGv/oUdH/76T/5KptXQGzrmtaTHdnWtL1/SZp57XyfsUu2ZNRjVmISIqdxfcWXK7xlsFCcVN/bIs/GF7BJ4h0XTxNLblrK9TM8uY1HyHzlxnoPlbn16Vgf8JB8a/8AoUdH/wC+k/8Akqj/AISD41/9Cjo//fSf/JVFgPW68k+LP/I/fDj/ALCX/te1o/4SD41/9Cjo/wD30n/yVXMeNtQ+JMl9otzLoLi9htPOKWmkR3iQT+e+CjkSbW2JExAbsDwejA+gqKh3XH/POP8A7+H/AOJo3XH/ADzj/wC/h/8AiaAJqKh3XH/POP8A7+H/AOJo3XH/ADzj/wC/h/8AiaAJqKh3XH/POP8A7+H/AOJo3XH/ADzj/wC/h/8AiaAJqgl/1kH++f8A0FqXdcf884/+/h/+JqORpvMhzHH9/j5z/dPtQItUVDuuP+ecf/fw/wDxNG64/wCecf8A38P/AMTQMmoqHdcf884/+/h/+Jo3XH/POP8A7+H/AOJoAmoqHdcf884/+/h/+Jo3XH/POP8A7+H/AOJoAmqCX/WQf75/9Bal3XH/ADzj/wC/h/8AiajkabzIcxx/f4+c/wB0+1Ai1RUO64/55x/9/D/8TRuuP+ecf/fw/wDxNAyaiod1x/zzj/7+H/4mjdcf884/+/h/+JoAmoqHdcf884/+/h/+Jo3XH/POP/v4f/iaAJqQdKi3XH/POP8A7+H/AOJppa4zxHHj/fP+FAinWFfatc2uu21olzYyCaRV+xKpNxsIOZM7sKoweqkcdcnjdrH8Tgf2TnAyl5alT/dPnp0rW2tjN7WNiptM/wCPL/trL/6G1Q1Npn/Hl/21l/8AQ2onsOO5eooorI0CiiigAooooAKgl/1kH++f/QWqeoJf9ZB/vn/0FqBE9FFFAwooooAKKKKACoJf9ZB/vn/0FqnqCX/WQf75/wDQWoAnooooAKKKKACiiigAqCX/AFkH++f/AEFqnqCX/WQf75/9BagCeiiigAooooAKKKKACoJf9ZB/vn/0FqnqCX/WQf75/wDQWoET0UUUDCiiigAooooAKgl/1kH++f8A0FqnqCX/AFkH++f/AEFqBE9FFFAwooooAKKKKACkHSlpB0oEf//Z
  2. dangiaothong

    dangiaothong Thành viên rất tích cực

    Tham gia ngày:
    10/09/2005
    Bài viết:
    4.854
    Đã được thích:
    7
    Sao không dùng cái chổi quét qua một cái?
    ----------------------------- Tự động gộp bài viết ---------------------------
    Khả năng nào hai ô của bạn dùng hai kiểu gõ khác nhau chăng?
  3. esc_force

    esc_force Thành viên rất tích cực

    Tham gia ngày:
    10/01/2007
    Bài viết:
    2.835
    Đã được thích:
    0
    Bác cho anh em xem cái lệnh Vlookup của bác cái! Từ đó mới có cơ sở các "thầy" khám bệnh qua thư.
  4. newchance2

    newchance2 Thành viên mới

    Tham gia ngày:
    24/07/2008
    Bài viết:
    316
    Đã được thích:
    0
    Tớ dùng chổi quét rồi đấy (cái Format Painter ý). Kiểu gõ của 2 ô đều giống nhau mà.

    Tớ chắc chắn là hàm Vlookup của tớ chuẩn rồi, vì khi tớ tự gõ tay lại các giá trị tìm kiếm (trong ví dụ của mình là gõ lại chữ "Cần Thơ" ở cả 2 bên), thì nó tìm ra được đúng giá trị, còn ko thì cứ toàn bị #NAME ý.
  5. F5F5

    F5F5 Thành viên rất tích cực

    Tham gia ngày:
    18/03/2011
    Bài viết:
    1.878
    Đã được thích:
    5
    Nếu thông tin ko cần bảo mật bác up lên MF để mọi ng thử xem thế nào
  6. ironfoot

    ironfoot Thành viên mới

    Tham gia ngày:
    08/06/2008
    Bài viết:
    1.160
    Đã được thích:
    0
    Bác gõ lại cái hàm Vlookup của bác nhé, xem kiểu của 2 ô kia có giống nhau k?
  7. F5F5

    F5F5 Thành viên rất tích cực

    Tham gia ngày:
    18/03/2011
    Bài viết:
    1.878
    Đã được thích:
    5
    Nhìn cái hình thớt up thì giá trị của A2 và B2 khác nhau nên ở C2 trả về giá trị FALSE, dùng Vlookup chắc chắn sẽ ko đc. Có lẽ là do Excel bị lỗi, chỉ nhìn hình nên khó biết được chính xác là lỗi gì.
  8. vohinh12345

    vohinh12345 Thành viên mới

    Tham gia ngày:
    11/12/2011
    Bài viết:
    98
    Đã được thích:
    0
    Kiểm tra lại dấu cách chưa bạn ơi. Rà soát lại dấu cách từ ô nguồn thử xem. Mình nghĩ nguyên nhân chỉ là do thừa dấu cách (khoảng trắng) thôi

    Mình thử format 2 ô khác nhau mà cũng có sao đâu

    [​IMG]
  9. Babut

    Babut Thành viên mới

    Tham gia ngày:
    24/12/2011
    Bài viết:
    1.557
    Đã được thích:
    1
    Khám bệnh kiểu này cứ như là bắt mạch qua sợi tơ ấy nhỉ ;)) Em thấy bác F5F5 có vẻ cao thủ về CNTT, bác chủ pic nên xin yahú của bác ấy rồi gửi cái file sang cho bác í khám bệnh là tốt nhất [:D]
  10. hugobossftu

    hugobossftu Thành viên mới

    Tham gia ngày:
    26/05/2007
    Bài viết:
    304
    Đã được thích:
    0
    Có thể là thừa một dấu cách. Thường gặp trường hợp thế này bạn nên dùng hàm =Trim(Địa chỉ ô) với từng ô để đưa hai ô về chung định dạng General (theo format default) của excel rồi dùng Vlookup sẽ ổn hơn.

    Hoặc có thể đưa về dạng Number bằng cách * 1 vào 2 ô chữ kia. Sau đó vlookup
    ----------------------------- Tự động gộp bài viết ---------------------------
    Muốn kiểm tra định dạng ô thì ấn Ctrl+1 sẽ thấy hết :)

Chia sẻ trang này