excel,,急一问...请高手入来求救.

想问excel高手一个问题,懂得请进来.急.谢谢!
如下图:我们工作订单很多.打以下个例子,谢了.
如何在B(订单*)中找出A(订单)一样的数字呢.谢谢!求高手请教一下...

有图大家帮忙看一下.谢谢

this one is easier
http://chandoo.org/wp/2010/06/17/compare-2-lists-in-excel/

download the first example, and need to create insert>nameif you dont create name it is also ok, just replace lst1 with the correct address range


http://www.techrepublic.com


http://www.bighungrygeek.com/compare-two-or-more-lists-with-isna-and-match/

[ 本帖最后由 81299129 於 2013-12-6 07:50 PM 编辑 ]

=vlookup("your cell or val",A$2:A$10,1,false)

PS This is not about programming.