vlookup“ false”返回0，而不是某些行的单元格值
[我正在从以下信息检索信息的单元格：绞合log full_ys oh crap.xlsx] infostats -sites'！$ h：$ j） （site = gamtoos河口; lat = 33°58'03.1“ s，long = 25°02'47.8” e）] 1
[第1行：site = gamtoos河口； long：= vlookup（$ q58;'[stranding log full_ys oh oh crap.xlsx] infostats -sites'！$ h：$ j; 2; 2; 0）（返回0）; lat：= vlookup（$ q58;'[stranding log full_ys oh oh crap.xlsx] infostats -sites'！$ h：$ j; 3; 3; 0）（返回0） 第2行：vlookup（$ q59;'[[stranding log full_ys oh crap.xlsx] infostats -sites'！$ h：$ h：$ j; 2; 0）（返回cell在stranding log full_ys oh oh crap.xlsx中的相应值站点'！$ h：$ j）] 2
我正在使用vlookup函数来检索来自其他文档的GPS位置。图像1包含我要从（site = gamtoos河口; lat = 33°58'03.1“ s，long = 25°02'47.8” e）中获取信息的单元。第二个图像显示了我使用的公式和2行。第一行具有来自图像1的信息（site = gamtoos河口），我想在LAT和长列中获取GPS位置。第二个显示了该公式如何适用于另一行。
函数：long = vlookup（$ q58;'[stranding log full_ys oh crap.xlsx] infostats -stites'！$ h：$ j; 2; 2; 0） crap.xlsx] infostats -sites'！$ h：$ h：$ j; 3; 3; 0）
lat = vlookup（$ q58;'[[stranding log full_ys oh 修复它？
我不确定如何添加图像，对不起。
谢谢！
[Cells that I am retrieving information from: Stranding log full_YS oh crap.xlsx]Infostats - sites'!$H:$J)
(Site= Gamtoos River Mouth; Lat= 33°58'03.1"S, Long= 25°02'47.8"E)]1
[Row 1: Site= Gamtoos River Mouth;
Long: =VLOOKUP($Q58;'[Stranding log full_YS oh crap.xlsx]Infostats - sites'!$H:$J;2;0) (returns 0);
Lat: =VLOOKUP($Q58;'[Stranding log full_YS oh crap.xlsx]Infostats - sites'!$H:$J;3;0) (returns 0)
Row 2: VLOOKUP($Q59;'[Stranding log full_YS oh crap.xlsx]Infostats - sites'!$H:$J;2;0) (returns corresponding value of cell in Stranding log full_YS oh crap.xlsx]Infostats - sites'!$H:$J)]2
I'm using the vlookup function to retrieve GPS locations from a different document. Image 1 contains the cells I'm retrieving information from (Site= Gamtoos River Mouth; Lat= 33°58'03.1"S, Long= 25°02'47.8"E). The second image shows the formula that I'm using and 2 rows. The 1st row has the information from image 1 (Site= Gamtoos River Mouth) and I want to get the GPS locations in the Lat and Long columns. The second shows how the formula worked for another row.
Function: Long =VLOOKUP($Q58;'[Stranding log full_YS oh crap.xlsx]Infostats - sites'!$H:$J;2;0)
Lat =VLOOKUP($Q58;'[Stranding log full_YS oh crap.xlsx]Infostats - sites'!$H:$J;3;0)
I would like to know why the formula is working for some rows but not others and how to fix it?
I'm not sure how to add images yet, sorry.
Thanks!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
如果您确定相关数据存在于电子表格中并且Vlookup不会捕获它，请花一些时间验证引用的单元格没有隐藏的空间或非打印字符。另外，请确保单元格遵循正确的数据类型。
您可以尝试在Notepad OG Notepad ++中制作新数据集。将数据在“数据”选项卡中的“导入指南”中导入数据，请确保为坐标设置正确的数据类型。看看这是否解决了问题。
您可以做的另一件事是使用= Trim和=数据上的清洁功能来调试错误。
If you are sure the relevant data exists in your spreadsheet and VLOOKUP is not catching it, take time to verify that the referenced cells don't have hidden spaces or non-printing characters. Also, ensure that the cells follow the correct data type.
You could try making at new data set in notepad og notepad++. import the data in a new excel sheet with the import guide in the data tab, make sure to set the correct data types for the coordinates. see if this solves the issue.
Another thing you could do is to use the =TRIM and =CLEAN functions on the data to debug the error.