EXCEL中选择对应 当C列=A列的其中一个数值时,D列自动等于A列所对应的B列值。

同一张表中,条件如下
1. A列-B列 唯一对应,当B等于一个值时A列有唯一值对用B列
2. C列为A列的打乱版本
3. 有D列与C列对应,现在需要找出D列的值

问题总结:当C列=A列的其中一个数值时,D列自动等于A列所对应的B列值。

希望解决的公式,能够在A列中自动查找与C列相等的值,并将对应的B填入D.

第1个回答  2011-08-15
It may be their category that's got spread their recognition throughout the globe. There's merely a praoclaiming that while utilizing fame arrive the problem. This renowned model is now facing view of the word as Louboutin shoes fakes are spreading effortlessly around the globe. Persons have found confused,Christian Louboutin Mens, as it is not easy to differentiate the $ 64000 Christian Louboutin shoes along with the replicas. Therefore it would be the good quality which is creating regarding getting pregnant it. Moreover the value also, the mirror image personality is also the basis reality of purchasing it.The creators with the above duplicate footwear are specific geniuses and they make replicas so totally that any person can fool his/her pals by making them understand someone else has obtained the genuine article. This can be difficult to believe that this is a reproduction. However,Christian Louboutin Heels, identifying a duplicate is tough, yet not genuinely impossible. A person will discover Christian shoes fakes if someone else visits a local store and compares his imperfect reproduction while using the perfect fundamental only one. Rather, a person should pay attention to the Louboutin signature on your sole within the shoe or visit dimensions print for just about any more authentications.The best buyers about this item are mostly the center and better middle-class folks with all the society,Christian Louboutin Bridal Shoes, as they neglect to definitely spend the money for superior asking price in the main designer Louboutin shoes. Contemplating their earnings capability, it is best to obtain an imitation around the originals, because they replicas are not unpleasant along with do final practically as long as the real ones. Nevertheless the a person that's looking to get his good mental satisfaction by ordering a unique designer produced sneakers will be wise to visit the dimensions conversion before selecting; it could be found in the website.Moreover,Christian Louboutin Sandals, fake shoes or boots are frequently spotted via prime factor that original Christian Louboutin sale can stretch half dimensions however replicas by no means stretch whatsoever. Therefore a person buys a sizing lower than his distinctive a person and finds it unpleasant; people should quickly establish that really must be not the true designer footwear. Additionally,Discount Christian Louboutin Shoes, basic footwear isn't dyed with chemical, nor use a good nasty smell. A worried consumer should truly follow these directions for your authentic type with this great model Louboutin by purchasing the originals.

<a href="" target="_blank" title="Christian Louboutin Heels,Christian Louboutin Outlet,
Black Peep Toe Christian Louboutins,Black Christian Louboutin">
第2个回答  2011-08-15
D1中输入公式:
=VLOOKUP(C1,A:B,2,)
往下拉就可以了。追问

这个公式我用过
但是不行啊
不知道是不是我用法不对
我一直很想知道,那个2 是什么意思???

追答

上面的公式意思是在A列中查找等于C1的数据,找到后返回同一行中B列的值,2表示相对于A列右侧的第二列,就是B列,即返回值所在的那一列。
公式没有问题,可能的原因是你的实际表格与你提问的描述不符造成的,所以你要是对这个函数比较熟悉的话,稍微调整一下就能用了。

本回答被提问者采纳
第3个回答  2011-08-15
=VLOOKUP(C1,$A$1:$B$9,2,FALSE)追问

为什么要$B$9?那个9是什么意思呢?我试的话是不是要改成最末尾的那个数字编号??

我一直很想知道,那个2 是什么意思???

追答

VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
=VLOOKUP(C1,$A$1:$B$9,2,FALSE)
Lookup_value 为需要在表格数组 (数组:用于建立可生成多个结果或可对在行和列中排列的一组参数进行运算的单个公式。数组区域共用一个公式;数组常量是用作参数的一组常量。)第一列中查找的数值。Lookup_value 可以为数值或引用。若 lookup_value 小于 table_array 第一列中的最小值,VLOOKUP 返回错误值 #N/A。

Table_array 为两列或多列数据。使用对区域或区域名称的引用。table_array 第一列中的值是由 lookup_value 搜索的值。这些值可以是文本、数字或逻辑值。文本不区分大小写。

Col_index_num 为 table_array 中待返回的匹配值的列序号。Col_index_num 为 1 时,返回 table_array 第一列中的数值;col_index_num 为 2,返回 table_array 第二列中的数值,以此类推。如果 col_index_num :

Range_lookup 为逻辑值,指定希望 VLOOKUP 查找精确的匹配值还是近似匹配值
具体实例可以参照excel的帮助文件,搜索vlookup即可

相关了解……

你可能感兴趣的内容

本站内容来自于网友发表,不代表本站立场,仅表示其个人看法,不对其真实性、正确性、有效性作任何的担保
相关事宜请发邮件给我们
© 非常风气网