{"id":2824,"date":"2026-01-18T22:35:57","date_gmt":"2026-01-18T15:35:57","guid":{"rendered":"https:\/\/teched.brainleader.org\/?p=2824"},"modified":"2026-11-03T14:25:42","modified_gmt":"2026-11-03T14:25:42","slug":"xlookup-function","status":"publish","type":"post","link":"https:\/\/teched.digital\/kh\/xlookup-function\/","title":{"rendered":"\u1796\u1793\u17d2\u1799\u179b\u17cb\u179b\u1798\u17d2\u17a2\u17b7\u178f\u1796\u17b8\u179a\u17bc\u1794\u1798\u1793\u17d2\u178f XLOOKUP"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u179a\u17bc\u1794\u1798\u1793\u17d2\u178f XLOOKUP \u179b\u17be\u1780\u1798\u17d2\u1798\u179c\u17b7\u1792\u17b8 Excel \u1787\u17b6\u179a\u17bc\u1794\u1798\u1793\u17d2\u178f\u178a\u17cf\u1798\u17b6\u1793\u1794\u17d2\u179a\u1799\u17c4\u1787\u1793\u17cd\u1798\u17bd\u1799\u178a\u17c2\u179b\u1794\u17d2\u179a\u17be\u1794\u17d2\u179a\u17b6\u179f\u17cb\u178a\u17be\u1798\u17d2\u1794\u17b8\u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u178f\u1798\u17d2\u179b\u17c3\u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784\u179b\u17c6\u178a\u17b6\u1794\u17cb\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799 (Range) \u1793\u17b7\u1784\u1794\u1784\u17d2\u17a0\u17b6\u1789\u179b\u1791\u17d2\u1792\u1795\u179b\u1799\u17c4\u1784\u178f\u17b6\u1798\u178f\u1798\u17d2\u179b\u17c3\u179f\u1798\u17d2\u179a\u17b6\u1794\u17cb\u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u1793\u17c4\u17c7\u17d4 \u179a\u17bc\u1794\u1798\u1793\u17d2\u178f\u1793\u17c1\u17c7\u1790\u17c2\u1798\u1791\u17b6\u17c6\u1784\u1780\u1798\u17d2\u179a\u17b7\u178f\u17b1\u17d2\u1799\u1794\u1784\u17d2\u17a0\u17b6\u1789\u178f\u1798\u17d2\u179b\u17c3\u178a\u17bc\u1785\u1791\u17b6\u17c6\u1784\u179f\u17d2\u179a\u17bb\u1784 (exact match) \u1794\u17d2\u179a\u17a0\u17b6\u1780\u17cb\u1794\u17d2\u179a\u17a0\u17c2\u179b (wildcards) \u1793\u17b7\u1784\u178f\u1798\u17d2\u179b\u17c3\u1794\u17d2\u179a\u1799\u17c4\u179b (regular expressions \u17a0\u17c5\u1780\u17b6\u178f\u17cb regex) \u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u178f\u17d2\u179a\u17a1\u1794\u17cb\u1796\u17b8\u1780\u17d2\u179a\u17c4\u1798\u17a1\u17be\u1784\u1791\u17c5\u179b\u17be\u200b (\u1785\u17d2\u179a\u17b6\u179f\/\u1794\u1789\u17d2\u1785\u17d2\u179a\u17b6\u179f) \u1793\u17b7\u1784\u1796\u17b7\u179f\u17c1\u179f\u1787\u17b6\u1793\u17c1\u17c7 \u17a2\u17b6\u1785\u179a\u1780\u178f\u1798\u17d2\u179b\u17c3\u1796\u17b8\u179b\u17c6\u178a\u17b6\u1794\u17cb\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u1787\u17bd\u179a\u1788\u179a\u1780\u17cf\u1794\u17b6\u1793 \u1787\u17bd\u179a\u178a\u17c1\u1780\u1780\u17cf\u1794\u17b6\u1793\u17d4 \u1787\u17b6\u179a\u17bd\u1798\u1798\u1780 \u179a\u17bc\u1794\u1798\u17bb\u1793 XLOOKUP \u1794\u1784\u17d2\u1780\u17be\u178f\u1798\u1780\u1787\u17c6\u1793\u17bd\u179f\u1798\u17bb\u1781\u1784\u17b6\u179a\u178a\u17c2\u179b\u1798\u17b6\u1793\u1798\u17bb\u1793\u17d7 \u178a\u17bc\u1785\u1787\u17b6 VLOOKUP, HLOOKUP, \u1793\u17b7\u1784 LOOKUP \u1795\u17d2\u178f\u179b\u17cb\u1797\u17b6\u1796\u1784\u17b6\u1799\u179f\u17d2\u179a\u17bd\u179b \u1793\u17b7\u1784\u1794\u178f\u17cb\u1794\u17c2\u1793\u1780\u17b6\u1793\u17cb\u178f\u17c2\u1785\u17d2\u179a\u17be\u1793\u17d4<\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-794e3cfa wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"has-x-large-font-size wp-block-paragraph\" style=\"font-style:normal;font-weight:700\">\u1782\u17c4\u179b\u178a\u17c5<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u178a\u17be\u1798\u17d2\u1794\u17b8\u179f\u17d2\u179c\u17c2\u1780\u179a\u1780\u178f\u1798\u17d2\u179b\u17c3\u1796\u17b8\u179b\u17c6\u178a\u17b6\u1794\u17cb\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"has-x-large-font-size wp-block-paragraph\" style=\"font-style:normal;font-weight:700\">\u179b\u1791\u17d2\u1792\u1795\u179b<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u1794\u1784\u17d2\u17a0\u17b6\u1789\u178f\u1798\u17d2\u179b\u17c3\u1799\u17c4\u1784\u178f\u17b6\u1798\u178f\u1798\u17d2\u179b\u17c3\u179f\u17d2\u179c\u17c2\u1784\u179a\u1780<\/p>\n<\/div>\n<\/div>\n\n\n\n<p class=\"has-x-large-font-size wp-block-paragraph\" style=\"font-style:normal;font-weight:700\">\u179a\u17bc\u1794\u1798\u1793\u17d2\u178f<\/p>\n\n\n\n<div class=\"language-excel\">\n  <code class=\"language-xls\"><span class=\"token operator\">=<\/span><a class=\"token function\" href=\"\/microsoft-office\/excel\/xlookup-function\/\">XLOOKUP<\/a><span class=\"token punctuation\">(<\/span><span>lookup<\/span><span class=\"token punctuation\">,<\/span><span>lookup_array<\/span><span class=\"token punctuation\">,<\/span><span>return_array<\/span><span class=\"token punctuation\">,<\/span><span class=\"token punctuation\">[<\/span>if_not_found<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span><span class=\"token punctuation\">[<\/span>match_mode<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span><span class=\"token punctuation\">[<\/span>search_mode<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><\/code>\n  <\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li>lookup &#8211; \u178f\u1798\u17d2\u179b\u17c3\u179f\u1798\u17d2\u179a\u17b6\u1794\u17cb\u179f\u17d2\u179c\u17c2\u1784\u179a\u1780<\/li>\n\n\n\n<li>lookup_array &#8211; \u179b\u17c6\u178a\u17b6\u1794\u17cb\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u179f\u1798\u17d2\u179a\u17b6\u1794\u17cb\u1780\u17b6\u179a\u179f\u17d2\u179c\u17c2\u1784\u179a\u1780<\/li>\n\n\n\n<li>return_array &#8211; \u179b\u17c6\u178a\u17b6\u1780\u17cb\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u179f\u1798\u17d2\u179a\u17b6\u1794\u17cb\u179b\u1791\u17d2\u1792\u1795\u179b\u1799\u17c4\u1784\u178f\u17b6\u1798\u178f\u1798\u17d2\u179b\u17c3\u179f\u1798\u17d2\u179a\u17b6\u1794\u17cb\u179f\u17d2\u179c\u17c2\u1784\u179a\u1780<\/li>\n\n\n\n<li>if_not_found &#8211; [\u1798\u17b7\u1793\u178f\u1798\u17d2\u179a\u17bc\u179c] \u178f\u1798\u17d2\u179b\u17c3\u1794\u1784\u17d2\u17a0\u17b6\u1789\u1785\u17c1\u1789 \u1794\u17d2\u179a\u179f\u17b7\u1793\u179a\u1780\u1798\u17b7\u1793\u1783\u17be\u1789\u178f\u1798\u17d2\u179b\u17c3\u178f\u17d2\u179a\u17bc\u179c\u178f\u17b6\u1798\u179b\u1780\u17d2\u1781\u1781\u178e\u17d2\u178c<\/li>\n\n\n\n<li>match_mode &#8211; [\u1798\u17b7\u1793\u178f\u1798\u17d2\u179a\u17bc\u179c] 0 = \u178f\u17d2\u179a\u17bc\u179c\u179b\u1780\u17d2\u1781\u1781\u178e\u17d2\u178c\u1794\u17d2\u179a\u17b6\u1780\u178a (\u179b\u17c6\u1793\u17b6\u17c6\u178a\u17be\u1798), -1 = \u178f\u17d2\u179a\u17bc\u179c\u179b\u1780\u17d2\u1781\u1781\u178e\u17d2\u178c\u1794\u17d2\u179a\u17b6\u1780\u178a \u17ac \u178f\u17bc\u1785\u1787\u17b6\u1784\u1794\u1793\u17d2\u1791\u17b6\u1794\u17cb, 1 = \u178f\u17d2\u179a\u17bc\u179c\u179b\u1780\u17d2\u1781\u1781\u178e\u17d2\u178c\u1794\u17d2\u179a\u17b6\u1780\u178a \u17ac \u1792\u17c6\u1787\u17b6\u1784\u1794\u1793\u17d2\u1791\u17b6\u1794\u17cb, 2 = \u1794\u17d2\u179a\u17a0\u17b6\u1780\u17cb\u1794\u17d2\u179a\u17a0\u17c2\u179b, 3 = \u178f\u1798\u17d2\u179b\u17c3\u1794\u17d2\u179a\u1799\u17c4\u179b<\/li>\n\n\n\n<li>search_mode &#8211; [\u1798\u17b7\u1793\u178f\u1798\u17d2\u179a\u17bc\u179c] 1 = \u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u1796\u17b8\u179b\u17be\u1785\u17bb\u17c7\u1780\u17d2\u179a\u17c4\u1798 (\u179b\u17c6\u1793\u17b6\u17c6\u178a\u17be\u1798), -1 = \u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u178f\u17d2\u179a\u17a1\u1794\u17cb\u1796\u17b8\u1780\u17d2\u179a\u17c4\u1798\u17a1\u17be\u1784\u1791\u17c5\u179b\u17be\u200b (\u1785\u17d2\u179a\u17b6\u179f\/\u1794\u1789\u17d2\u1785\u17d2\u179a\u17b6\u179f), 2 = \u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u178f\u17b6\u1798\u179b\u17c6\u178a\u17b6\u1794\u17cb\u17a2\u1780\u17d2\u1781\u179a\u1780\u1780\u17d2\u179a\u1798, -2 = \u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u178f\u17b6\u1798\u179b\u17c6\u178a\u17b6\u1794\u17cb\u17a2\u1780\u17d2\u1781\u179a\u1780\u1780\u17d2\u179a\u1798\u1785\u17d2\u179a\u17b6\u179f<\/li>\n<\/ul>\n\n\n\n<p class=\"has-x-large-font-size wp-block-paragraph\" id=\"h-\u1780-\u179a\u1794-\u179a-\u1794-\u179a-\u179f-\u179a-\u1794\u1798\u1793-\u178f-xlookup\" style=\"font-style:normal;font-weight:700\">\u1780\u17b6\u179a\u1794\u17d2\u179a\u17be\u1794\u17d2\u179a\u17b6\u179f\u17cb\u179a\u17bc\u1794\u1798\u1793\u17d2\u178f XLOOKUP<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u179a\u17bc\u1794\u1798\u1793\u17d2\u178f XLOOKUP \u1787\u17b6\u1791\u17c6\u1793\u17be\u1794\u1780\u1798\u17d2\u1798\u1793\u17c3\u179a\u17bc\u1794\u1798\u1793\u17d2\u178f LOOKUP \u1791\u17b6\u17c6\u1784\u17a2\u179f\u17cb\u179b\u17be\u1780\u1798\u17d2\u1798\u179c\u17b7\u1792\u17b8 Excel (\u1782\u17b7\u178f\u178f\u17d2\u179a\u17bc\u179c\u1786\u17d2\u1793\u17b6\u17c6\u17e2\u17e0\u17e2\u17e5)\u17d4 \u1798\u17bb\u1781\u1784\u17b6\u179a\u1793\u17c1\u17c7 \u17a2\u17b6\u1785\u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u178f\u1798\u17d2\u179b\u17c3\u1796\u17b8\u179b\u17c6\u178a\u17b6\u1794\u17cb\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u1787\u17bd\u179a\u1788\u179a \u17ac\u1787\u17bd\u179a\u178a\u17c1\u1780 \u1793\u17b7\u1784\u179b\u17c6\u178a\u17b6\u1794\u17cb\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u1798\u17bb\u1781\u1780\u17d2\u179a\u17c4\u1799\u1794\u17b6\u1793\u1791\u17c0\u178f\u17d4 \u1796\u17b7\u179f\u17c1\u179f\u1787\u17b6\u1784\u1793\u17c1\u17c7 \u179c\u17b6\u17a2\u17b6\u1785\u1794\u1784\u17d2\u17a0\u17b6\u1789\u178f\u1798\u17d2\u179b\u17c3\u179b\u17be\u179f\u1796\u17b8\u1798\u17bd\u1799\u1780\u17d2\u1793\u17bb\u1784\u1796\u17c1\u179b\u178f\u17c2\u1798\u17bd\u1799 \u1793\u17b7\u1784\u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u1794\u17b6\u1793\u179b\u17bf\u1793 \u179b\u17d2\u17a2\u179f\u1798\u17d2\u179a\u17b6\u1794\u17cb\u1780\u17b6\u179a\u1794\u17d2\u179a\u17be\u1794\u17d2\u179a\u17b6\u179f\u17cb\u1780\u17d2\u1793\u17bb\u1784\u179b\u17c6\u178a\u17b6\u1794\u17cb\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u1785\u17d2\u179a\u17be\u1793\u17d7\u17d4<\/p>\n\n\n\n<div class=\"wp-block-yoast-seo-table-of-contents yoast-table-of-contents\"><h2><strong>\u1798\u17b6\u178f\u17b7\u1780\u17b6\u1780\u17d2\u1793\u17bb\u1784\u17a2\u178f\u17d2\u1790\u1794\u1791\u1793\u17c1\u17c7<\/strong><\/h2><ul><li><a href=\"\/#exact-match\" data-level=\"2\">\u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd\u1791\u17b8\u17e1\u17c8 \u178f\u17d2\u179a\u17bc\u179c\u179b\u1780\u17d2\u1781\u1781\u178e\u17d2\u178c\u1794\u17d2\u179a\u17b6\u1780\u178a<\/a><\/li><li><a href=\"\/#h-%E1%9E%A7%E1%9E%91-%E1%9E%A0%E1%9E%9A%E1%9E%8E-%E1%9E%91-%E1%9F%A2-%E1%9E%94-%E1%9E%9A%E1%9E%A0-%E1%9E%80-%E1%9E%94-%E1%9E%9A%E1%9E%A0-%E1%9E%9B\" data-level=\"2\">\u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd\u1791\u17b8\u17e2\u17c8 \u1794\u17d2\u179a\u17a0\u17b6\u1780\u17cb\u1794\u17d2\u179a\u17a0\u17c2\u179b<\/a><\/li><li><a href=\"\/#h-%E1%9E%A7%E1%9E%91-%E1%9E%A0%E1%9E%9A%E1%9E%8E-%E1%9E%91-%E1%9F%A3-%E1%9E%9A%E1%9E%80%E1%9E%8F%E1%9E%98-%E1%9E%9B-%E1%9E%85-%E1%9E%9A-%E1%9E%93%E1%9E%80-%E1%9E%93-%E1%9E%84%E1%9E%9B%E1%9E%80-%E1%9E%81%E1%9E%81%E1%9E%8E-%E1%9E%8C%E1%9E%8F-%E1%9E%98-%E1%9E%99\" data-level=\"2\">\u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd\u1791\u17b8\u17e3\u17c8 \u179a\u1780\u178f\u1798\u17d2\u179b\u17c3\u1785\u17d2\u179a\u17be\u1793\u1780\u17d2\u1793\u17bb\u1784\u179b\u1780\u17d2\u1781\u1781\u178e\u17d2\u178c\u178f\u17c2\u1798\u17bd\u1799<\/a><\/li><li><a href=\"\/#h-%E1%9E%A7%E1%9E%91-%E1%9E%A0%E1%9E%9A%E1%9E%8E-%E1%9E%91-%E1%9F%A4-%E1%9E%8F%E1%9E%98-%E1%9E%9B-%E1%9E%94-%E1%9E%9A%E1%9E%9F%E1%9E%96-%E1%9E%9C%E1%9E%82-%E1%9E%93-%E1%9E%96-%E1%9E%9A\" data-level=\"2\">\u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd\u1791\u17b8\u17e4\u17c8 \u178f\u1798\u17d2\u179b\u17c3\u1794\u17d2\u179a\u179f\u1796\u17d2\u179c\u1782\u17d2\u1793\u17b6\u1796\u17b8\u179a<\/a><\/li><li><a href=\"\/#h-%E1%9E%A7%E1%9E%91-%E1%9E%A0%E1%9E%9A%E1%9E%8E-%E1%9E%91-%E1%9F%A5-%E1%9E%80-%E1%9E%8E%E1%9E%8F-%E1%9E%96-%E1%9E%80-%E1%9E%99%E1%9E%9F%E1%9E%98-%E1%9E%9A-%E1%9E%94-%E1%9E%80-%E1%9E%9A%E1%9E%9A%E1%9E%80%E1%9E%98-%E1%9E%93%E1%9E%83-%E1%9E%89%E1%9E%9B%E1%9E%91-%E1%9E%92%E1%9E%95%E1%9E%9B-not-found\" data-level=\"2\">\u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd\u1791\u17b8\u17e5\u17c8 \u1780\u17c6\u178e\u178f\u17cb\u1796\u17b6\u1780\u17d2\u1799\u179f\u1798\u17d2\u179a\u17b6\u1794\u17cb \u1780\u17b6\u179a\u179a\u1780\u1798\u17b7\u1793\u1783\u17be\u1789\u179b\u1791\u17d2\u1792\u1795\u179b (Not found)<\/a><\/li><li><a href=\"\/#h-%E1%9E%A7%E1%9E%91-%E1%9E%A0%E1%9E%9A%E1%9E%8E-%E1%9E%91-%E1%9F%A6-%E1%9E%96%E1%9E%A0-%E1%9E%9B%E1%9E%80-%E1%9E%81%E1%9E%81%E1%9E%8E-%E1%9E%8C-%E1%9E%8F%E1%9E%98-%E1%9E%9B-%E1%9E%9F%E1%9E%98-%E1%9E%9A-%E1%9E%94-%E1%9E%9F-%E1%9E%9C-%E1%9E%84%E1%9E%9A%E1%9E%80%E1%9E%85-%E1%9E%9A-%E1%9E%93\" data-level=\"2\">\u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd\u1791\u17b8\u17e6 \u1796\u17a0\u17bb\u179b\u1780\u17d2\u1781\u1781\u178e\u17d2\u178c (\u178f\u1798\u17d2\u179b\u17c3\u179f\u1798\u17d2\u179a\u17b6\u1794\u17cb\u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u1785\u17d2\u179a\u17be\u1793)<\/a><\/li><\/ul><\/div>\n\n\n\n<h2 id=\"exact-match\" class=\"wp-block-heading\" style=\"font-style:normal;font-weight:700\">\u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd\u1791\u17b8\u17e1\u17c8 \u178f\u17d2\u179a\u17bc\u179c\u179b\u1780\u17d2\u1781\u1781\u178e\u17d2\u178c\u1794\u17d2\u179a\u17b6\u1780\u178a<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u178a\u17c4\u1799\u179b\u17c6\u1793\u17b6\u17c6\u178a\u17be\u1798 \u179a\u17bc\u1794\u1798\u1793\u17d2\u178f XLOOKUP \u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u178f\u17d2\u179a\u17bc\u179c\u179b\u1780\u17d2\u1781\u1781\u178e\u17d2\u178c\u1794\u17d2\u179a\u17b6\u1780\u178a\u17d4 \u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd\u1781\u17b6\u1784\u1780\u17d2\u179a\u17c4\u1798\u1793\u17c1\u17c7 \u179a\u17bc\u1794\u1798\u1793\u17d2\u178f XLOOKUP \u1780\u17c6\u178e\u178f\u17cb\u17b1\u17d2\u1799\u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u178f\u1798\u17d2\u179b\u17c3\u179b\u1780\u17cb\u1796\u17b8 column E \u178f\u17b6\u1798\u179b\u1780\u17d2\u1781\u1781\u178e\u17d2\u178c\u1785\u17c6\u178e\u1784\u1787\u17be\u1784\u1797\u17b6\u1796\u1799\u1793\u17d2\u178f\u1793\u17c5 column B \u17d4 \u179a\u17bc\u1794\u1798\u1793\u17d2\u178f\u178a\u17c2\u179b\u1794\u17b6\u1793\u1794\u1789\u17d2\u1785\u17bc\u179b\u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784 H5 \u1782\u17ba\u17d6<\/p>\n\n\n\n<div class=\"language-excel\">\n  <code class=\"language-xls\"><span class=\"token operator\">=<\/span><a class=\"token function\" href=\"https:\/\/www.techedcambodia.com\/2025\/10\/xlookup-function.html\">XLOOKUP<\/a><span class=\"token punctuation\">(<\/span><span class=\"token cell selector\">H4<\/span><span class=\"token punctuation\">,<\/span><span class=\"token range selector\">B5:B9<\/span><span class=\"token punctuation\">,<\/span><span class=\"token range selector\">E5:E9<\/span><span class=\"token punctuation\">)<\/span><\/code><\/div>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6b010f79810b4&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6b010f79810b4\" class=\"wp-block-image size-large wp-lightbox-container\"><img decoding=\"async\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/teched.digital\/kh\/wp-content\/uploads\/2026\/01\/1-01-1024x429.png\" alt=\"\" class=\"wp-image-4251\"\/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\tdata-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.thisImage.buttonRight\"\n\t\t\tdata-wp-style--top=\"state.thisImage.buttonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n<h2 id=\"h-\u17a7\u1791-\u17a0\u179a\u178e-\u1791-\u17e2-\u1794-\u179a\u17a0-\u1780-\u1794-\u179a\u17a0-\u179b\" class=\"wp-block-heading\" style=\"font-style:normal;font-weight:700\">\u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd\u1791\u17b8\u17e2\u17c8 \u1794\u17d2\u179a\u17a0\u17b6\u1780\u17cb\u1794\u17d2\u179a\u17a0\u17c2\u179b<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u178a\u17be\u1798\u17d2\u1794\u17b8\u17a2\u17b6\u1785\u1792\u17d2\u179c\u17be\u17b1\u17d2\u1799 XLOOKUP \u17a2\u17b6\u1785\u179a\u1780\u178f\u1798\u17d2\u179b\u17c3\u1794\u17d2\u179a\u17a0\u17b6\u1780\u17cb\u1794\u17d2\u179a\u17a0\u17c2\u179b\u1794\u17b6\u1793 \u1799\u17be\u1784\u178f\u17d2\u179a\u17bc\u179c\u1780\u17c6\u178e\u178f\u17cb match_mode \u1780\u17d2\u1793\u17bb\u1784\u179a\u17bc\u1794\u1798\u1793\u17d2\u178f\u17d4 \u1780\u17d2\u1793\u17bb\u1784\u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd\u1781\u17b6\u1784\u1780\u17d2\u179a\u17c4\u1798\u1793\u17c1\u17c7 \u1799\u17be\u1784\u1793\u17b9\u1784\u1798\u1780\u179a\u1780\u1797\u17b6\u1782\u179a\u1799\u179b\u1780\u17cb\u1794\u1789\u17d2\u1785\u17bb\u17c7\u178f\u1798\u17d2\u179b\u17c3\u178f\u17b6\u1798\u1794\u179a\u17b7\u1798\u17b6\u178e \u17ac\u1785\u17c6\u1793\u17bd\u1793\u1791\u17b7\u1789\u17d4 \u179a\u17bc\u1794\u1798\u1793\u17d2\u178f F5 \u1780\u17c6\u178e\u178f\u17cb match_mode -1 \u178a\u17be\u1798\u17d2\u1794\u17b8\u1794\u1784\u17d2\u17a0\u17b6\u1789\u178f\u1798\u17d2\u179b\u17c3\u178f\u17bc\u1785\u1787\u17b6\u1784\u1794\u1793\u17d2\u1791\u17b6\u1794\u17cb\u17d4<\/p>\n\n\n\n<div class=\"language-excel\">\n  <code class=\"language-xls\"><span class=\"token operator\">=<\/span><a class=\"token function\" href=\"https:\/\/www.techedcambodia.com\/2025\/10\/xlookup-function.html\">XLOOKUP<\/a><span class=\"token punctuation\">(<\/span><span class=\"token cell selector\">E5<\/span><span class=\"token punctuation\">,<\/span><span class=\"token range selector\">B5:B9<\/span><span class=\"token punctuation\">,<\/span><span class=\"token range selector\">C5:C9<\/span><span class=\"token punctuation\">,<\/span><span class=\"token punctuation\">,<\/span><span class=\"token operator\">-<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span><\/code>\n<\/div>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6b010f79814f3&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6b010f79814f3\" class=\"wp-block-image size-large wp-lightbox-container\"><img decoding=\"async\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/teched.digital\/kh\/wp-content\/uploads\/2026\/01\/Excel-Xlookkup-2-01-1024x429.png\" alt=\"\" class=\"wp-image-4252\"\/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\tdata-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.thisImage.buttonRight\"\n\t\t\tdata-wp-style--top=\"state.thisImage.buttonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n<h2 id=\"h-\u17a7\u1791-\u17a0\u179a\u178e-\u1791-\u17e3-\u179a\u1780\u178f\u1798-\u179b-\u1785-\u179a-\u1793\u1780-\u1793-\u1784\u179b\u1780-\u1781\u1781\u178e-\u178c\u178f-\u1798-\u1799\" class=\"wp-block-heading\" style=\"font-style:normal;font-weight:700\">\u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd\u1791\u17b8\u17e3\u17c8 \u179a\u1780\u178f\u1798\u17d2\u179b\u17c3\u1785\u17d2\u179a\u17be\u1793\u1780\u17d2\u1793\u17bb\u1784\u179b\u1780\u17d2\u1781\u1781\u178e\u17d2\u178c\u178f\u17c2\u1798\u17bd\u1799<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">XLOOKUP \u17a2\u17b6\u1785\u178a\u17c2\u179b\u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u1785\u17d2\u179a\u17be\u1793\u1787\u17b6\u1784\u1798\u17bd\u1799\u1780\u17d2\u1793\u17bb\u1784\u1796\u17c1\u179b\u178f\u17c2\u1798\u17bd\u1799 (\u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd \u179b\u17c6\u178a\u17b6\u1794\u17cb\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u1780\u17d2\u1793\u17bb\u1784\u178f\u17b6\u179a\u17b6\u1784\u1785\u17d2\u179a\u17be\u1793\u1787\u17bd\u179a\u1788\u179a) \u178a\u17c4\u1799\u1794\u17d2\u179a\u17be\u179a\u17bc\u1794\u1798\u1793\u17d2\u178f\u178f\u17c2\u1798\u17bd\u1799\u17d4 \u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd\u1781\u17b6\u1784\u1780\u17d2\u179a\u17c4\u1798\u1794\u1784\u17d2\u17a0\u17b6\u1789\u1796\u17b8\u179a\u1794\u17c0\u1794\u178a\u17c2\u179b XLOOKUP \u17a2\u17b6\u1785\u1794\u17d2\u179a\u17be\u1794\u17d2\u179a\u17b6\u179f\u17cb\u178a\u17be\u1798\u17d2\u1794\u17b8\u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u178f\u1798\u17d2\u179b\u17c3\u178a\u17c2\u179b\u1785\u1784\u17cb\u1794\u17b6\u1793\u1785\u17c6\u1793\u17bd\u1793\u1794\u17b8\u178a\u17c4\u1799\u1794\u17d2\u179a\u17be\u179a\u17bc\u1794\u1798\u1793\u17d2\u178f\u178f\u17c2\u1798\u17bd\u1799\u17d4 \u179a\u17bc\u1794\u1798\u1793\u17d2\u178f\u1780\u17d2\u1793\u17bb\u1784 C5 \u1782\u17ba\u17d6<\/p>\n\n\n\n<div class=\"language-excel\">\n  <code class=\"language-xls\"><span class=\"token operator\">=<\/span><a class=\"token function\" href=\"https:\/\/www.techedcambodia.com\/2025\/10\/xlookup-function.html\">XLOOKUP<\/a><span class=\"token punctuation\">(<\/span><span class=\"token cell selector\">B5<\/span><span class=\"token punctuation\">,<\/span><span class=\"token range selector\">B8:B15<\/span><span class=\"token punctuation\">,<\/span><span class=\"token range selector\">C8:E15<\/span><span class=\"token punctuation\">)<\/span><\/code><\/div>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6b010f79818b1&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6b010f79818b1\" class=\"wp-block-image size-large wp-lightbox-container\"><img decoding=\"async\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/teched.digital\/kh\/wp-content\/uploads\/2026\/01\/Excel-Xlookkup-Multiple-values-01-1024x591.png\" alt=\"\" class=\"wp-image-4253\"\/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\tdata-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.thisImage.buttonRight\"\n\t\t\tdata-wp-style--top=\"state.thisImage.buttonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u178f\u17b6\u1798\u179a\u1799\u17c8\u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd\u1793\u17c1\u17c7 \u1799\u17be\u1784\u1783\u17be\u1789\u1790\u17b6\u1787\u17bd\u179a\u1788\u179a D \u1793\u17b7\u1784 E \u1794\u1784\u17d2\u17a0\u17b6\u1789\u178f\u1798\u17d2\u179b\u17c3\u179f\u17d2\u179c\u17c2\u1784\u1794\u17d2\u179a\u179c\u178f\u17d2\u178f\u17b7\u1799\u17c4\u1784\u178f\u17b6\u1798\u178f\u1798\u17d2\u179b\u17c3 \u17ac\u179b\u1780\u17d2\u1781\u1781\u178e\u17d2\u178c\u178f\u17c2\u1798\u17bd\u1799 \u1780\u17d2\u1793\u17bb\u1784\u1796\u17c1\u179b\u178f\u17c2\u1798\u17bd\u1799\u17d4<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784\u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd\u1781\u17b6\u1784\u179b\u17be\u1793\u17c1\u17c7 \u1799\u17be\u1784\u1794\u17d2\u179a\u17be XLOOKUP \u17b1\u17d2\u1799\u1794\u1784\u17d2\u17a0\u17b6\u1789\u178f\u1798\u17d2\u179b\u17c3 \u17e3\u1793\u17c3\u179b\u17c6\u178a\u17b6\u1794\u17cb\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u1796\u17b8\u178f\u17b6\u179a\u17b6\u1784\u17d4 \u1794\u17d2\u179a\u179f\u17b7\u1793\u1794\u17be\u1782\u17c4\u179b\u178a\u17c5\u179a\u1794\u179f\u17cb\u1799\u17be\u1784\u17b1\u17d2\u1799\u1794\u1784\u17d2\u17a0\u1789\u178f\u17b6\u1798\u179b\u1780\u17d2\u1781\u1781\u178e\u17d2\u178c\u1785\u17d2\u179a\u17be\u1793\u178a\u17bc\u1785\u1787\u17b6 \u1794\u17bb\u1782\u17d2\u1782\u179b\u17b7\u1780\u1791\u17b6\u17c6\u1784\u17a2\u179f\u17cb\u1780\u17d2\u1793\u17bb\u1784\u1793\u17b6\u1799\u1780\u178a\u17d2\u1781\u17b6\u1793\u1795\u17d2\u1793\u17c2\u1780\u179a\u178a\u17d2\u178b\u1794\u17b6\u179b(Administration) XLOOKUP \u1798\u17b7\u1793\u1798\u17c2\u1793\u1787\u1798\u17d2\u179a\u17be\u179f\u179b\u17d2\u17a2\u1793\u17c4\u17c7\u1791\u17c1 \u178a\u17c4\u1799\u179f\u17b6\u179a\u1790\u17b6 \u179c\u17b6\u1794\u1784\u17d2\u17a0\u17b6\u1789\u1798\u17bd\u1799\u1787\u17bd\u179a\u1794\u17c9\u17bb\u178e\u17d2\u178e\u17c4\u17c7\u17d4 \u1780\u17d2\u1793\u17bb\u1784\u1780\u179a\u178e\u17b8\u1793\u17c1\u17c7 \u1799\u17be\u1784\u17a2\u17b6\u1785\u1794\u17d2\u179a\u17be\u1798\u17bb\u1781\u1784\u17b6\u179a \u17ac\u179a\u17bc\u1794\u1798\u1793\u17d2\u178f&nbsp;<a href=\"https:\/\/techedcambodia.blogspot.com\/filter-function\">FILTER function<\/a>&nbsp;\u178a\u17c2\u179b\u179c\u17b6\u17a2\u17b6\u1785\u1794\u1784\u17d2\u17a0\u17b6\u1789\u179b\u1791\u17d2\u1792\u1795\u179b\u1796\u17b6\u1780\u17cb\u1796\u17d0\u1793\u17d2\u1792\u1791\u17b6\u17c6\u1784\u17a2\u179f\u17cb\u1785\u17d2\u179a\u17be\u1793\u1787\u17bd\u179a\u1788\u179a \u1793\u17b7\u1784\u1787\u17bd\u179a\u178a\u17c1\u1780\u17d4<\/p>\n\n\n\n<h2 id=\"h-\u17a7\u1791-\u17a0\u179a\u178e-\u1791-\u17e4-\u178f\u1798-\u179b-\u1794-\u179a\u179f\u1796-\u179c\u1782-\u1793-\u1796-\u179a\" class=\"wp-block-heading\" style=\"font-style:normal;font-weight:700\">\u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd\u1791\u17b8\u17e4\u17c8 \u178f\u1798\u17d2\u179b\u17c3\u1794\u17d2\u179a\u179f\u1796\u17d2\u179c\u1782\u17d2\u1793\u17b6\u1796\u17b8\u179a<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">XLOOKUP \u17a2\u17b6\u1785\u178a\u17c2\u179b\u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u178f\u1798\u17d2\u179b\u17c3\u1794\u17d2\u179a\u179f\u1796\u17d2\u179c\u1782\u17d2\u1793\u17b6\u1796\u17b8\u179a \u178a\u17c4\u1799\u1780\u17b6\u179a\u1794\u1784\u17d2\u1780\u1794\u17cb XLOOKUP \u1780\u17d2\u1793\u17bb\u1784 XLOOKUP \u1798\u17bd\u1799\u1791\u17c0\u178f\u17d4 \u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd\u1781\u17b6\u1784\u1780\u17d2\u179a\u17c4\u1798\u1793\u17c1\u17c7 XLOOKUP \u1781\u17b6\u1784\u1780\u17d2\u1793\u17bb\u1784\u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u178f\u1798\u17d2\u179b\u17c3\u1791\u17b6\u17c6\u1784\u17a2\u179f\u17cb\u1780\u17d2\u1793\u17bb\u1784\u1787\u17bd\u179a\u178a\u17c1\u1780 Glass \u17a0\u17be\u1799\u178a\u17be\u179a\u178f\u17bd\u179a\u1787\u17b6\u179b\u17c6\u178a\u17b6\u1780\u17cb\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u179f\u1798\u17d2\u179a\u17b6\u1794\u17cb\u179b\u1791\u17d2\u1792\u1795\u179b\u1799\u17c4\u1784\u178f\u17b6\u1798\u178f\u1798\u17d2\u179b\u17c3\u179f\u1798\u17d2\u179a\u17b6\u1794\u17cb\u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u1793\u17c3 XLOOKUP \u1781\u17b6\u1784\u1780\u17d2\u179a\u17c5\u17d4 \u1785\u17c6\u1796\u17c4\u17c7 XLOOKUP \u1781\u17b6\u1784\u1780\u17d2\u179a\u17c5\u179c\u17b7\u1789 \u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u178f\u1798\u17d2\u179b\u17c3\u1780\u17d2\u1793\u17bb\u1784\u1780\u17d2\u179a\u17bb\u1798 B \u17a0\u17be\u1799\u179b\u1791\u17d2\u1792\u1795\u179b\u1794\u1784\u17d2\u17a0\u17b6\u1789\u178f\u1798\u17d2\u179b\u17c3 17.25 \u17d4<\/p>\n\n\n\n<div class=\"language-excel\">\n  <code class=\"language-xls\"><span class=\"token operator\">=<\/span><a class=\"token function\" href=\"https:\/\/www.techedcambodia.com\/2025\/10\/xlookup-function.html\">XLOOKUP<\/a><span class=\"token punctuation\">(<\/span><span class=\"token cell selector\">I6<\/span><span class=\"token punctuation\">,<\/span><span class=\"token range selector\">C4:F4<\/span><span class=\"token punctuation\">,<\/span><a class=\"token function\" href=\"\/functions\/xlookup-function\">XLOOKUP<\/a><span class=\"token punctuation\">(<\/span><span class=\"token cell selector\">I5<\/span><span class=\"token punctuation\">,<\/span><span class=\"token range selector\">B5:B9<\/span><span class=\"token punctuation\">,<\/span><span class=\"token range selector\">C5:F9<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><\/code><\/div>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6b010f7981caa&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6b010f7981caa\" class=\"wp-block-image size-large wp-lightbox-container\"><img decoding=\"async\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/teched.digital\/kh\/wp-content\/uploads\/2026\/01\/Excel-Xlookkup1-01-1024x517.png\" alt=\"\" class=\"wp-image-4249\"\/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\tdata-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.thisImage.buttonRight\"\n\t\t\tdata-wp-style--top=\"state.thisImage.buttonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n<h2 id=\"h-\u17a7\u1791-\u17a0\u179a\u178e-\u1791-\u17e5-\u1780-\u178e\u178f-\u1796-\u1780-\u1799\u179f\u1798-\u179a-\u1794-\u1780-\u179a\u179a\u1780\u1798-\u1793\u1783-\u1789\u179b\u1791-\u1792\u1795\u179b-not-found\" class=\"wp-block-heading\" style=\"font-style:normal;font-weight:700\">\u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd\u1791\u17b8\u17e5\u17c8 \u1780\u17c6\u178e\u178f\u17cb\u1796\u17b6\u1780\u17d2\u1799\u179f\u1798\u17d2\u179a\u17b6\u1794\u17cb \u1780\u17b6\u179a\u179a\u1780\u1798\u17b7\u1793\u1783\u17be\u1789\u179b\u1791\u17d2\u1792\u1795\u179b (Not found)<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u178a\u17bc\u1785\u179a\u17bc\u1794\u1798\u1793\u17d2\u178f\u1791\u17bc\u1791\u17c5\u1795\u17d2\u179f\u17c1\u1784\u1791\u17c0\u178f\u178a\u17c2\u179a \u1793\u17c5\u1796\u17c1\u179b\u179a\u1780\u1798\u17b7\u1793\u1783\u17be\u1789\u178f\u1798\u17d2\u179b\u17c3\u178f\u17b6\u1798\u179b\u1780\u17d2\u1781\u1781\u178e\u17d2\u178c XLOOKUP \u1793\u17b7\u1784\u1794\u1784\u17d2\u17a0\u17b6\u1789\u179b\u1791\u17d2\u1792\u1795\u179b #N\/A \u17d4 \u1787\u17b6\u1798\u17bd\u1799\u1782\u17d2\u1793\u17b6\u1793\u17c1\u17c7\u178a\u17c2\u179a XLOOKUP \u1798\u17b6\u1793\u1798\u17bb\u1781\u1784\u17b6\u179a\u17a2\u17b6\u1785\u17b1\u17d2\u1799\u1799\u17be\u1784\u1794\u1789\u17d2\u1785\u17bc\u179b\u179f\u17b6\u179a\u1795\u17d2\u179f\u17c1\u1784\u1796\u17b8\u1793\u17c1\u17c7\u1787\u17c6\u1793\u17bd\u179f\u1796\u17b6\u1780\u17d2\u1799 Not found \u1794\u17b6\u1793\u17d4 \u1782\u17bd\u179a\u17b1\u17d2\u1799\u178a\u17b9\u1784\u178a\u17c2\u179b\u1790\u17b6 #N\/A \u1794\u1789\u17d2\u1787\u17b6\u1780\u17cb\u1796\u17b8\u179b\u1791\u17d2\u1792\u1795\u179b \u179a\u1780\u1798\u17b7\u1793\u1783\u17be\u1789 \u1798\u17b7\u1793\u1798\u17b6\u1793\u178f\u1798\u17d2\u179b\u17c3\u178f\u17d2\u179a\u17bc\u179c\u179b\u1780\u17d2\u1781\u1781\u178e\u17d2\u178c \u1782\u17d2\u1798\u17b6\u1793\u179b\u1791\u17d2\u1792\u1795\u179b\u17d4 \u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd\u17c8 \u179b\u1791\u17d2\u1792\u1795\u179b &#8220;\u179a\u1780\u1798\u17b7\u1793\u1783\u17be\u1789&#8221; \u1793\u17c5\u1796\u17c1\u179b\u178f\u1798\u17d2\u179b\u17c3\u179f\u1798\u17d2\u179a\u17b6\u1794\u17cb\u179f\u17d2\u179c\u17c2\u1784\u179a\u1780 (lookup value) \u1798\u17b7\u1793\u1798\u17b6\u1793\u1780\u17d2\u1793\u17bb\u1784\u179b\u17c6\u178a\u17b6\u1794\u17cb\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u17d4<\/p>\n\n\n\n<div class=\"language-excel\">\n  <code class=\"language-xls\"><span class=\"token operator\">=<\/span><a class=\"token function\" href=\"https:\/\/www.techedcambodia.com\/2025\/10\/xlookup-function.html\">XLOOKUP<\/a><span class=\"token punctuation\">(<\/span><span class=\"token cell selector\">H4<\/span><span class=\"token punctuation\">,<\/span><span class=\"token range selector\">B5:B9<\/span><span class=\"token punctuation\">,<\/span><span class=\"token range selector\">E5:E9<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"Not found\"<\/span><span class=\"token punctuation\">)<\/span>\n  <\/code>\n<\/div>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6b010f798204a&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6b010f798204a\" class=\"wp-block-image size-large wp-lightbox-container\"><img decoding=\"async\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/teched.digital\/kh\/wp-content\/uploads\/2026\/01\/Excel-Xlookkup1-Multiple-Criteria-01-1024x600.png\" alt=\"\" class=\"wp-image-4250\"\/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\tdata-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.thisImage.buttonRight\"\n\t\t\tdata-wp-style--top=\"state.thisImage.buttonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u1780\u1793\u17d2\u179b\u17c2\u1784\u1796\u17b6\u1780\u17d2\u1799 &#8220;\u179a\u1780\u1798\u17b7\u1793\u1783\u17be\u1789&#8221; \u1793\u17c1\u17c7 \u1799\u17be\u1784\u17a2\u17b6\u1785\u1780\u17c2\u1791\u17c5\u1787\u17b6\u1796\u17b6\u1780\u17d2\u1799\u17a2\u17d2\u179c\u17b8\u1780\u17cf\u1794\u17b6\u1793\u178a\u17c2\u179a\u17b1\u17d2\u1799\u178f\u17c2\u178a\u17b6\u1780\u17cb\u179c\u17b6\u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784 &#8220;&#8221; \u179f\u1798\u17d2\u179a\u17b6\u1794\u17cb\u1796\u17b6\u1780\u17d2\u1799(\u17a2\u1780\u17d2\u179f\u179a)\u17d4<\/p>\n\n\n\n<p class=\"teched-block-notice wp-block-paragraph\" style=\"font-style:normal;font-weight:400\">\u1785\u17c6\u178e\u17b6\u17c6\u17c8 \u179f\u17bc\u1798\u1794\u17d2\u179a\u1799\u17d0\u178f\u17d2\u1793 \u1794\u17d2\u179a\u179f\u17b7\u1793\u1794\u17be\u1799\u17be\u1784\u1780\u17c6\u178e\u178f\u17cb\u1780\u1793\u17d2\u179b\u17c2\u1784\u179f\u17b6\u179a &#8220;Not found&#8221; \u1787\u17b6\u1798\u17bd\u1799 (&#8220;&#8221;) \u1791\u1791\u17c1 \u179c\u17b6\u1793\u17b9\u1784\u179b\u17b6\u1780\u17cb\u178f\u1798\u17d2\u179b\u17c3 #N\/A \u178a\u17c2\u179b\u1794\u1784\u17d2\u17a0\u17b6\u1789\u179b\u17c6\u1793\u17b6\u17c6\u178a\u17be\u1798\u179a\u1794\u179f\u17cb XLOOKUP \u17d4 \u1794\u17d2\u179a\u179f\u17b7\u1793\u1785\u1784\u17cb\u1794\u17b6\u1793\u178f\u1798\u17d2\u179b\u17c3\u179b\u17c6\u1793\u17b6\u17c6\u178a\u17be\u1798\u1796\u17c1\u179b\u179a\u1780\u1798\u17b7\u1793\u1783\u17be\u1789\u179f\u17bc\u1798\u179a\u17c6\u179b\u1784\u1798\u17bb\u1781\u1784\u17b6\u179a\u179f\u17b6\u179a\u1793\u17c1\u17c7 \u178a\u17c4\u1799\u179f\u179a\u179f\u17c1\u179a (,,) \u1794\u17c2\u1794\u1793\u17c1\u17c7\u179c\u17b7\u1789\u17d4<\/p>\n\n\n\n<h2 id=\"h-\u17a7\u1791-\u17a0\u179a\u178e-\u1791-\u17e6-\u1796\u17a0-\u179b\u1780-\u1781\u1781\u178e-\u178c-\u178f\u1798-\u179b-\u179f\u1798-\u179a-\u1794-\u179f-\u179c-\u1784\u179a\u1780\u1785-\u179a-\u1793\" class=\"wp-block-heading has-x-large-font-size\"><strong>\u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd\u1791\u17b8\u17e6 \u1796\u17a0\u17bb\u179b\u1780\u17d2\u1781\u1781\u178e\u17d2\u178c (\u178f\u1798\u17d2\u179b\u17c3\u179f\u1798\u17d2\u179a\u17b6\u1794\u17cb\u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u1785\u17d2\u179a\u17be\u1793)<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u178f\u17b6\u1798\u1792\u1798\u17d2\u1798\u178f\u17b6 XLOOKUP \u1781\u17d2\u179b\u17bd\u1793\u179c\u17b6\u17a2\u178f\u17cb\u17a2\u17b6\u1785\u179a\u1780\u178f\u1798\u17d2\u179b\u17c3\u178a\u17c2\u179b\u1798\u17b6\u1793\u1796\u17a0\u17bb\u179b\u1780\u17d2\u1781\u1781\u178e\u17d2\u178c \u17ac\u1799\u1780\u178f\u1798\u17d2\u179b\u17c3\u179f\u1798\u17d2\u179a\u17b6\u1794\u17cb\u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u1785\u17d2\u179a\u17be\u1793\u1791\u17c5\u179a\u1780\u178f\u1798\u17d2\u179b\u17c3\u1798\u17bd\u1799\u1791\u17c1\u17d4 \u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd \u1799\u17be\u1784\u1785\u1784\u17cb\u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u178f\u1798\u17d2\u179b\u17c3 \u17a2\u17b6\u179c Hoodie \u1791\u17c6\u17a0\u17c6 Medium \u1796\u178e\u17cc Blue \u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784\u178f\u17b6\u179a\u17b6\u1784\u179b\u17c6\u178a\u17b6\u1794\u17cb\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799 \u178a\u17c2\u179b\u1794\u17d2\u179a\u1797\u17c1\u1791\u17a2\u17b6 \u1791\u17c6\u17a0\u17c6 \u1796\u178e\u17cc \u179f\u17d2\u1790\u17b7\u178f\u1780\u17d2\u1793\u17bb\u1784\u1787\u17bd\u179a\u1788\u179a\u1795\u17d2\u179f\u17c1\u1784\u17d7\u1782\u17d2\u1793\u17b6\u17d4 \u1791\u17c4\u17c7\u1794\u17b8 XLOOKUP \u1782\u17d2\u1798\u17b6\u1793\u1798\u17bb\u1781\u1784\u17b6\u179a\u1794\u17c2\u1794\u1793\u17c1\u17c7 \u1794\u17c9\u17bb\u1793\u17d2\u178a\u17c2\u1799\u17be\u1784\u17a2\u17b6\u1785\u1794\u17d2\u179a\u17be \u1780\u1793\u17d2\u179f\u17c4\u1798\u1796\u17b8\u1787\u1782\u178e\u17b7\u178f (Boolean logic) \u1794\u17b6\u1793\u17d4 \u1780\u17b6\u179a\u17a2\u1793\u17bb\u179c\u178f\u17d2\u178f\u1794\u17c2\u1794\u1793\u17c1\u17c7 \u1799\u17be\u1784\u1780\u17c6\u178e\u178f\u17cb\u178f\u1798\u17d2\u179b\u17c3\u178a\u17c2\u179b\u1785\u1784\u17cb\u179a\u1780 1 \u1793\u17b7\u1784\u178f\u1798\u17d2\u179b\u17c3\u1795\u17d2\u179f\u17c1\u1784 0 \u178a\u17c4\u1799\u179f\u17d2\u179c\u17c2\u1784\u1794\u17d2\u179a\u179c\u178f\u17d2\u178f\u17b7\u17d4 \u1798\u17be\u179b\u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd \u1780\u17d2\u1793\u17bb\u1784 H8 \u178a\u17be\u1798\u17d2\u1794\u17b8\u1799\u179b\u17cb\u1796\u17b8\u178a\u17c6\u178e\u17be\u179a\u1780\u17b6\u179a\u1793\u17c1\u17c7\u17d4<\/p>\n\n\n\n<div class=\"language-excel\">\n  <code class=\"language-xls\">\n    <span class=\"token operator\">=<\/span><a class=\"token function\" href=\"\/functions\/xlookup-function\">XLOOKUP<\/a><span class=\"token punctuation\">(<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span><span class=\"token punctuation\">(<\/span><span class=\"token range selector\">B5:B15<\/span><span class=\"token operator\">=<\/span><span class=\"token cell selector\">H5<\/span><span class=\"token punctuation\">)<\/span><span class=\"token operator\">*<\/span><span class=\"token punctuation\">(<\/span><span class=\"token range selector\">C5:C15<\/span><span class=\"token operator\">=<\/span><span class=\"token cell selector\">H6<\/span><span class=\"token punctuation\">)<\/span><span class=\"token operator\">*<\/span><span class=\"token punctuation\">(<\/span><span class=\"token range selector\">D5:D15<\/span><span class=\"token operator\">=<\/span><span class=\"token cell selector\">H7<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><span class=\"token range selector\">E5:E15<\/span><span class=\"token punctuation\">)<\/span>\n  <\/code>\n<\/div>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6b010f798230b&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6b010f798230b\" class=\"wp-block-image size-large wp-lightbox-container\"><img decoding=\"async\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/teched.digital\/kh\/wp-content\/uploads\/2026\/01\/Excel-Xlookkup1-Multiple-Criteria-01-1024x600.png\" alt=\"\" class=\"wp-image-4250\"\/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\tdata-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.thisImage.buttonRight\"\n\t\t\tdata-wp-style--top=\"state.thisImage.buttonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u179c\u17b8\u178a\u17c1\u17a2\u17bc\u1796\u1793\u17d2\u1799\u179b\u17cb\u179b\u1798\u17d2\u17a2\u17b7\u178f<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"\u1796\u1793\u17d2\u1799\u179b\u17cb\u1785\u17d2\u1794\u17b6\u179f\u17cb\u17d7 \u1796\u17b8\u179a\u17bc\u1794\u1798\u1793\u17d2\u178f XLOOKUP Function\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/2tLEWV34V00?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<a href=\"https:\/\/github.com\/kirikroem\/teched\/raw\/main\/resources\/excel\/Excel-XLOOKUP.xlsx\" class=\"teched-download-btn customize excel-file\">\n  <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n       viewBox=\"131 -131 512 512\"\n       aria-hidden=\"true\">\n    <path d=\"M362.6-88.5v240.2L265.7,54l-35.4,34.7L387,245.5L543.8,88.7L509.1,54l-97.7,97V-88.5H362.6z M131,292v46.5h512V292H131z\"\/>\n  <\/svg>\n  <span>Excel-XLOOKUP.xlsx<\/span>\n<\/a>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u179a\u17bc\u1794\u1798\u1793\u17d2\u178f XLOOKUP \u179b\u17be\u1780\u1798\u17d2\u1798\u179c\u17b7\u1792\u17b8 Excel \u1787\u17b6\u179a\u17bc\u1794\u1798\u1793\u17d2\u178f\u178a\u17cf\u1798\u17b6\u1793\u1794\u17d2\u179a\u1799\u17c4\u1787\u1793\u17cd\u1798\u17bd\u1799\u178a\u17c2\u179b\u1794\u17d2\u179a\u17be\u1794\u17d2\u179a\u17b6\u179f\u17cb\u178a\u17be\u1798\u17d2\u1794\u17b8\u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u178f\u1798\u17d2\u179b\u17c3\u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784\u179b\u17c6\u178a\u17b6\u1794\u17cb\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799 (Range) \u1793\u17b7\u1784\u1794\u1784\u17d2\u17a0\u17b6\u1789\u179b\u1791\u17d2\u1792\u1795\u179b\u1799\u17c4\u1784\u178f\u17b6\u1798\u178f\u1798\u17d2\u179b\u17c3\u179f\u1798\u17d2\u179a\u17b6\u1794\u17cb\u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u1793\u17c4\u17c7\u17d4 \u179a\u17bc\u1794\u1798\u1793\u17d2\u178f\u1793\u17c1\u17c7\u1790\u17c2\u1798\u1791\u17b6\u17c6\u1784\u1780\u1798\u17d2\u179a\u17b7\u178f\u17b1\u17d2\u1799\u1794\u1784\u17d2\u17a0\u17b6\u1789\u178f\u1798\u17d2\u179b\u17c3\u178a\u17bc\u1785\u1791\u17b6\u17c6\u1784\u179f\u17d2\u179a\u17bb\u1784 (exact match) \u1794\u17d2\u179a\u17a0\u17b6\u1780\u17cb\u1794\u17d2\u179a\u17a0\u17c2\u179b (wildcards) \u1793\u17b7\u1784\u178f\u1798\u17d2\u179b\u17c3\u1794\u17d2\u179a\u1799\u17c4\u179b (regular expressions \u17a0\u17c5\u1780\u17b6\u178f\u17cb regex) \u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u178f\u17d2\u179a\u17a1\u1794\u17cb\u1796\u17b8\u1780\u17d2\u179a\u17c4\u1798\u17a1\u17be\u1784\u1791\u17c5\u179b\u17be\u200b (\u1785\u17d2\u179a\u17b6\u179f\/\u1794\u1789\u17d2\u1785\u17d2\u179a\u17b6\u179f) \u1793\u17b7\u1784\u1796\u17b7\u179f\u17c1\u179f\u1787\u17b6\u1793\u17c1\u17c7 \u17a2\u17b6\u1785\u179a\u1780\u178f\u1798\u17d2\u179b\u17c3\u1796\u17b8\u179b\u17c6\u178a\u17b6\u1794\u17cb\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u1787\u17bd\u179a\u1788\u179a\u1780\u17cf\u1794\u17b6\u1793 \u1787\u17bd\u179a\u178a\u17c1\u1780\u1780\u17cf\u1794\u17b6\u1793\u17d4 \u1787\u17b6\u179a\u17bd\u1798\u1798\u1780 \u179a\u17bc\u1794\u1798\u17bb\u1793 XLOOKUP \u1794\u1784\u17d2\u1780\u17be\u178f\u1798\u1780\u1787\u17c6\u1793\u17bd\u179f\u1798\u17bb\u1781\u1784\u17b6\u179a\u178a\u17c2\u179b\u1798\u17b6\u1793\u1798\u17bb\u1793\u17d7 \u178a\u17bc\u1785\u1787\u17b6 VLOOKUP, HLOOKUP, \u1793\u17b7\u1784 LOOKUP \u1795\u17d2\u178f\u179b\u17cb\u1797\u17b6\u1796\u1784\u17b6\u1799\u179f\u17d2\u179a\u17bd\u179b \u1793\u17b7\u1784\u1794\u178f\u17cb\u1794\u17c2\u1793\u1780\u17b6\u1793\u17cb\u178f\u17c2\u1785\u17d2\u179a\u17be\u1793\u17d4 \u1782\u17c4\u179b\u178a\u17c5 \u178a\u17be\u1798\u17d2\u1794\u17b8\u179f\u17d2\u179c\u17c2\u1780\u179a\u1780\u178f\u1798\u17d2\u179b\u17c3\u1796\u17b8\u179b\u17c6\u178a\u17b6\u1794\u17cb\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799 \u179b\u1791\u17d2\u1792\u1795\u179b \u1794\u1784\u17d2\u17a0\u17b6\u1789\u178f\u1798\u17d2\u179b\u17c3\u1799\u17c4\u1784\u178f\u17b6\u1798\u178f\u1798\u17d2\u179b\u17c3\u179f\u17d2\u179c\u17c2\u1784\u179a\u1780 \u179a\u17bc\u1794\u1798\u1793\u17d2\u178f =XLOOKUP(lookup,lookup_array,return_array,[if_not_found],[match_mode],[search_mode]) \u1780\u17b6\u179a\u1794\u17d2\u179a\u17be\u1794\u17d2\u179a\u17b6\u179f\u17cb\u179a\u17bc\u1794\u1798\u1793\u17d2\u178f XLOOKUP \u179a\u17bc\u1794\u1798\u1793\u17d2\u178f XLOOKUP \u1787\u17b6\u1791\u17c6\u1793\u17be\u1794\u1780\u1798\u17d2\u1798\u1793\u17c3\u179a\u17bc\u1794\u1798\u1793\u17d2\u178f LOOKUP \u1791\u17b6\u17c6\u1784\u17a2\u179f\u17cb\u179b\u17be\u1780\u1798\u17d2\u1798\u179c\u17b7\u1792\u17b8 Excel (\u1782\u17b7\u178f\u178f\u17d2\u179a\u17bc\u179c\u1786\u17d2\u1793\u17b6\u17c6\u17e2\u17e0\u17e2\u17e5)\u17d4 \u1798\u17bb\u1781\u1784\u17b6\u179a\u1793\u17c1\u17c7 \u17a2\u17b6\u1785\u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u178f\u1798\u17d2\u179b\u17c3\u1796\u17b8\u179b\u17c6\u178a\u17b6\u1794\u17cb\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u1787\u17bd\u179a\u1788\u179a \u17ac\u1787\u17bd\u179a\u178a\u17c1\u1780 \u1793\u17b7\u1784\u179b\u17c6\u178a\u17b6\u1794\u17cb\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u1798\u17bb\u1781\u1780\u17d2\u179a\u17c4\u1799\u1794\u17b6\u1793\u1791\u17c0\u178f\u17d4 \u1796\u17b7\u179f\u17c1\u179f\u1787\u17b6\u1784\u1793\u17c1\u17c7 \u179c\u17b6\u17a2\u17b6\u1785\u1794\u1784\u17d2\u17a0\u17b6\u1789\u178f\u1798\u17d2\u179b\u17c3\u179b\u17be\u179f\u1796\u17b8\u1798\u17bd\u1799\u1780\u17d2\u1793\u17bb\u1784\u1796\u17c1\u179b\u178f\u17c2\u1798\u17bd\u1799 \u1793\u17b7\u1784\u179f\u17d2\u179c\u17c2\u1784\u179a\u1780\u1794\u17b6\u1793\u179b\u17bf\u1793 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3749,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"video","meta":{"footnotes":""},"categories":[23],"tags":[127,128],"class_list":["post-2824","post","type-post","status-publish","format-video","has-post-thumbnail","hentry","category-excel","tag-excel-file","tag-excel-formula","post_format-post-format-video"],"_links":{"self":[{"href":"https:\/\/teched.digital\/kh\/wp-json\/wp\/v2\/posts\/2824","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teched.digital\/kh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teched.digital\/kh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teched.digital\/kh\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/teched.digital\/kh\/wp-json\/wp\/v2\/comments?post=2824"}],"version-history":[{"count":1,"href":"https:\/\/teched.digital\/kh\/wp-json\/wp\/v2\/posts\/2824\/revisions"}],"predecessor-version":[{"id":4396,"href":"https:\/\/teched.digital\/kh\/wp-json\/wp\/v2\/posts\/2824\/revisions\/4396"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teched.digital\/kh\/wp-json\/wp\/v2\/media\/3749"}],"wp:attachment":[{"href":"https:\/\/teched.digital\/kh\/wp-json\/wp\/v2\/media?parent=2824"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teched.digital\/kh\/wp-json\/wp\/v2\/categories?post=2824"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teched.digital\/kh\/wp-json\/wp\/v2\/tags?post=2824"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}