[请问] excel函数问题请教 yeeting PTT批踢踢实业坊

[请问] excel函数问题请教

楼主: yeeting (allfamilyisyourfamily) 2018-04-25 13:42:51

https://i.imgur.com/JCSmLo0.jpg
如图
蓝框框里的资料是私人电话通讯录，
想问要如何将蓝框的电话对应到红框框中人名的"私人电话"
是用VLOOKUP函数吗因为看了网络上说明还是不太懂如何写函数
再贵求高手版友解答谢谢QQ

作者: newacc (XD) 2018-04-25 13:57:00

=VLOOKUP(D2,$Q$2:$R$16,2,FALSE)

楼主: yeeting (allfamilyisyourfamily) 2018-04-25 14:09:00

n大谢谢你～～～～～

继续阅读

[请问] 玩fps游戏鼠标会乱飘XLcock [请问] 网购商品退货chpb [请问] 光男joned [请问] 房间天花板漏水是否该找水电工处理?banana2014 Fw: [问题] 钻石海绵的清洁方式lueichun [请问] 请问哪个ptt app 最好用?abou199040 [请问] 请问各位辛亥路有哪段禁机车吗?peter127 [请问] 有什么适合发心得文的冷门看版otherwind [请问] 请问台北有那里可以短暂洗澡asdfg567 [请问] yahoo mail无法开启j9771909

Contact Us: admin [ a t ] ucptt.com