どうも、初めまして。
こちらのブログでは初めて記事を執筆させていただきます。
DSSに加入してまだ一年とちょっとの半人前です。
これからたまにこうして記事を書いていくと思いますので、以後お見知りおきを。
さて、今回はExcelに登場するらしい新しい関数の紹介です。
このブログにも記事が上がっていますが、Excelの関数にはVLOOKUPやHLOOKUPという関数がありますね。
Vertical(ヴァーティカル)LOOKUPの略でVLOOKUP、Horizontal(ホリゾンタル)LOOKUPでHLOOKUPなのですが、これらはその名の通りVertical(垂直)とHorizontal(水平)に検索をかける関数でした。
新しく登場するXLOOKUPは垂直水平両方に検索をかけられるようになるそうです。
XLOOKUPはこのほかにも様々な改善がされているようです。
Office Insiders向けの提供が今年始まるようですが、一般公開はまだのようです。
続報が入り次第、記事にします。
それでは。
By kimama
2019年09月05日
Excelの新関数、XLOOKUPについて
posted by dss at 20:03| Comment(5)
| フリートーク
https://wakelet.com/wake/wWzXdyemFLCDm0gkHYfiN
https://wakelet.com/wake/KpmrOer4sjXKH41M_s-RK
https://wakelet.com/wake/kVS76z5Ba72pBMx3YtOP5
https://wakelet.com/wake/3_L2zccA9wm4yNvPEqGaE
https://wakelet.com/wake/-6bfF69Bh8jkxLKG1-jDh
https://wakelet.com/wake/m3kL5ILXDoAxea3vfJKWg
https://wakelet.com/wake/0qDISnvC2cr1P5Jf3xy_s
https://wakelet.com/wake/EHPA3WBKNrrZYGf8GT0IQ
https://wakelet.com/wake/xvxIxQy5qMCF0tH_MZ2zy
https://wakelet.com/wake/UL9bUNFoH64rPNyOsK9oC
https://wakelet.com/wake/tnWbBJho_lhdGHIHKbyBi
https://wakelet.com/wake/50Grulvw7YK-lolPt1wbS
https://wakelet.com/wake/NbHCydURQ6SZvTe141c30
https://wakelet.com/wake/Cnk2DcHebWRn4FR622OLd
https://wakelet.com/wake/pUXVUYjYv4ozURT4S0aKS
https://wakelet.com/wake/4l6znPSQEWSlFPYiLanxf
https://wakelet.com/wake/uO8qNuSivgzMOosMg1Cqh
https://wakelet.com/wake/amcHf_K5xXPfln6YB-7_i
https://wakelet.com/wake/xda3GjrUk36aZeamm-si0
https://wakelet.com/wake/qNKoe0e2ZO-6o2R2_iIjq
https://wakelet.com/wake/g4-t2tZwNEHeNWryYn0Pj
https://wakelet.com/wake/TMAiDcq5RRQs2FDWDv6SW
https://wakelet.com/wake/kGhB-zLG-oXjdrVi1yNBE
https://wakelet.com/wake/X40yipYjzWJnQcDRNYsE5
https://wakelet.com/wake/xpzOJ8od8L98ZQwh1_SMA
https://wakelet.com/wake/xAzbxgt22DsiB6DUwTgCn
https://wakelet.com/wake/VYuBJunCLOlo6cLS2Ie2g
https://wakelet.com/wake/-ZyanjMY0z3_BGgx3F9ds
https://wakelet.com/wake/fyI6IfAjAjVaG7Hbfqcyv
https://wakelet.com/wake/Al5eHLoSnyJ4q7uvPB2E3
https://wakelet.com/wake/kUlm7Pu9maTgB-FvnGZ2C
https://wakelet.com/wake/MJ_SGFbBpGR1TyhMZJ6nE
https://wakelet.com/wake/lSIILVcKz7V9vr97FX8-o
https://wakelet.com/wake/0RV3b_TRpVczeDatt4Lv2
https://wakelet.com/wake/P7bF9b9CHaujwA6aZZ_Mp
https://wakelet.com/wake/8VE3Y1nwZF5MRtUJ5ZhHI
https://wakelet.com/wake/UMM9ww5IX-_ITQvzB1v6u
https://wakelet.com/wake/xUz9i23WkRZm-h0_n-HV0
https://wakelet.com/wake/lggI2IYM5yTEHnlkcKWeo
https://wakelet.com/wake/OsMkJHFbpmUC56qLXIzX7
https://wakelet.com/wake/g7iYfIOLEpxN-VDNhUlt-
https://wakelet.com/wake/xqyeHw1fOiQjhax4IbI2Y
https://wakelet.com/wake/00y-5nft8jqTLkaxzdAhh
https://wakelet.com/wake/OFhE50UArLY8NJkKf-VLY
https://wakelet.com/wake/5z7glO5TwADWrRqO_vvtR
https://wakelet.com/wake/P_1l4dLn4MdXZhQ5RIqN4
https://wakelet.com/wake/8VBdb_MRwvkU2w_FEA5wd
https://wakelet.com/wake/wD5vmUPql-jNff4iVZAY8
https://wakelet.com/wake/eeQv3d3QOiesmhmf1qsBU
https://wakelet.com/wake/cCdHcI5tysMZJ0LnV1n6o
https://wakelet.com/wake/7XdxEx_crP1Uq5hIOSgES
https://wakelet.com/wake/G8sDv6yG2YnMEz9_hUNke
https://wakelet.com/wake/g2Z4jN_23E9ClCuNisuvw
https://wakelet.com/wake/mH_rsnVAn-NFXpYTLRjZn
https://wakelet.com/wake/oENOuM-hdDuosqjtqD0y1
https://wakelet.com/wake/6RO7x7HNzuaio0ix62FiR
https://wakelet.com/wake/5jR0crUajxiKiFkVpD0PZ
https://wakelet.com/wake/-adSIcxrE5nvA4VkUUu27
https://wakelet.com/wake/VnyLYLA5QB3Qrz8ZxWTcX
https://wakelet.com/wake/FTzvwWLOMZmDVSVADqy6s
https://wakelet.com/wake/1lDmXDZZvgQjE1s7LzV-G
https://wakelet.com/wake/gmpce_SABgfJ-0ToDzE5Q
https://imgur.com/S0nVqff
https://imgur.com/n5e3FgJ
https://imgur.com/otBCqmk
https://imgur.com/OrEG5mq
https://imgur.com/EokaQW5
https://imgur.com/lP5M0zn
https://imgur.com/uN7OaZn
https://imgur.com/re9LGZN
https://imgur.com/3X0KmRu
https://imgur.com/NPGszbG
https://imgur.com/txNlHOH
https://imgur.com/ArYAyaE
https://imgur.com/kWHhAOi
https://imgur.com/5VUpB1s
https://imgur.com/qDRDUiC
https://imgur.com/L8ybTNE
https://imgur.com/VeOiGBT
https://imgur.com/HxQTff6
https://imgur.com/kSo6xEY
https://imgur.com/F94hzFx
https://imgur.com/ayB7ITY
https://imgur.com/UsrVfb3
https://imgur.com/jo2mOnT
https://imgur.com/XthoSQJ
https://imgur.com/SlgtvPA
https://imgur.com/gkdBV2V
https://imgur.com/1ONKcEa
https://imgur.com/lW1SpSA
https://imgur.com/NTe2i6f
https://imgur.com/6jfck3y
https://imgur.com/zaxoIm1
https://imgur.com/KLVzBnB
https://imgur.com/t7hWLHG
https://imgur.com/MOgRi5u
https://imgur.com/PYW06Jl
https://imgur.com/iqNLYJm
https://imgur.com/NLVCzQI
https://imgur.com/OGR0iZJ
https://imgur.com/L8vJawz
https://imgur.com/wyl5Tvo
https://imgur.com/FeMWH7h
https://imgur.com/0SKpXaW
https://imgur.com/pvaOeR8
https://imgur.com/LkyT5wj
https://imgur.com/sMzbcGb
https://imgur.com/G8i8KrY
https://imgur.com/6Blyt5Q
https://imgur.com/dSpQsKQ
https://imgur.com/XQ7bcEu
https://imgur.com/CAvHd3n
https://imgur.com/aEFVF0M
https://imgur.com/pGJgXEo
https://imgur.com/aQKisSK
https://imgur.com/hGz9WuR
https://imgur.com/Yxqd9WV
https://imgur.com/LPEzvX8
https://imgur.com/oUM6mqG
https://imgur.com/fNXe8r7
https://imgur.com/IBOZdcx
https://imgur.com/0IqTPp9
https://imgur.com/mdy5joQ
https://imgur.com/pK8OyOu
https://imgur.com/cZLtKAG
https://imgur.com/yKvxOhe