Forum Discussion
Increasing Specific Values
Hi Anonymous ,
Try using LOOKUPVALUE() Lookup I would break this into two columns, so that you are comfortable with what you are doing, and then after combine the two formulas into 1. First use LOOKUPVALUE () to search the other table for the name of the city based on the test column and the value it is looking up is the city in your first table. Return a zero perhaps if not found. Then the if looks at that column and if there is a city name, get the value from the other table, else keep the value from your first table.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Hi Anonymous ,
Try using LOOKUPVALUE() Lookup I would break this into two columns, so that you are comfortable with what you are doing, and then after combine the two formulas into 1. First use LOOKUPVALUE () to search the other table for the name of the city based on the test column and the value it is looking up is the city in your first table. Return a zero perhaps if not found. Then the if looks at that column and if there is a city name, get the value from the other table, else keep the value from your first table.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel