问题描述
我正在处理一个 excel 文件,我正在尝试使用 vLookUp 函数映射"一些值.
I am working with an excel file and I am trying to "map" some values with the vLookUp function.
vLookUp 函数的第一个参数让我头疼:该函数适用于某些值(以文本格式手动输入)...但不适用于预先生成的值(相同的...但生成从 ERP 系统...).我检查以确保我正在寻找相同性质"的值(文本与文本)......但我不知道为什么前 3 个值(手动输入)很好......但最后 3 个(预生成)给我一个 #N/A 错误:它必须是格式"的不同......但我找不到区别在哪里......
The first parameter of the vLookUp function is giving me headaches: The function works with certains values (typed by hand in a text format)...but doesnt work with pre-generated values (the sames ones...but generated from an ERP system..). I checked to make sure that I was looking for "same nature" values ( text vs text ) ...but I can't find out why the first 3 values (typed by hand) are fine... but the last 3 (pre generated) gives me a #N/A error: It has to be a difference of "format" ..but I can't find out where's the difference...
这是使用的公式:=VLOOKUP(D1;$A$1:$B$219;2;FALSE)
This is the formula used: =VLOOKUP(D1;$A$1:$B$219;2;FALSE)
1008600 379.99 1008600 379.99
1008601 379.99 1008601 379.99
1010600 449.99 1010600 449.99
1010601 449.99 1010601 #N/A
1013600 489.99 1013600 #N/A
1014601 509.99 1014601 #N/A
1015600 569.99
1018603 679.99
1019600 809.99
谢谢!
推荐答案
使用这个公式可以解决 RocketDonkey 强调的问题
Using this formula will address the issue highlighted by RocketDonkey
=VLOOKUP(TEXT(D1,"#"),$A$1:$B$219,2,FALSE)
这篇关于找不到错误:VLOOKUP 没有返回值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!