嵌套vlookup的问题 [英] problem with nested vlookup

问题描述

我有一个像这样的电子表格

原产地zip低目的地zip高目的地zip值
33625 30000 31000 50
33625 31000 32000 40
33625 32000 33000 30
33625 33000 34000 20

我想输入33625的原始邮政编码和33777的目标邮政编码，并检查我的目标zip是否在低目标zip和高目标zip的范围之间，并返回20的值.因此，它的2个条件是它必须与原始zip匹配，dest zip需要介于低zip和高zip之间才能返回特定的值.我知道我在某个地方犯了一个愚蠢的错误.



谢谢您预先提供的所有帮助.

i have a spreadsheet like this

origin zip low dest zip high dest zip value
33625 30000 31000 50
33625 31000 32000 40
33625 32000 33000 30
33625 33000 34000 20

I would like to enter the origin zip of 33625 and destination zip 33777 and have it check to see if my dest zip fall in between the range of the low dest zip and high dest zip and return the value of 20. so its 2 criteria, it has to match the origin zip and dest zip needs to fall in between the low and high zip to return me a specific value. I know Im make a dumb mistake somewhere.



Thanks for all of the help in advance

推荐答案

如果四列分别是A，B，C和D，并且行是1到5，且带有标题，那么"= VLOOKUP(33777，B2:D5,3)"应该给您答案.

VLOOKUP查找表B2到D5的数字，并在这种情况下返回第3列中的值.第二列是没有意义的，因为您的第一列已经将邮政编码分为多个范围.

If the four columns are A, B, C, and D, and the rows are 1 thru 5, with header, then "=VLOOKUP(33777,B2:D5,3)" should give you your answer.

VLOOKUP finds the number if the table B2 to D5 and returns the value in the 3rd column in this case. The second column is meaningless since your first column already splits the zipcodes into ranges.

这篇关于嵌套vlookup的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！