Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
LOOKUP() Function Help
I'm trying to write a function that will determine the county of an address based on the city. So far, I have created a table with several counties forming the vertical axis and then a list of all of the cities in each county running along the horizontal axis. It looks something like this:
County 1 City1 City2 City3
County 2 City4 City5 City6
County 3 City7 City8 City9
County 4 City10 City11 City12
My function looks like this:
=LOOKUP("City8", [County]1:[City]3, 1, false)
My understanding of the formula tells me that this function should search for City8 and then return the corresponding value in the first column of the table. So, it should return "County 3". However, I just get a blank cell.
The only time that I don't get a blank cell is when I search for the county instead of the city. For example:
=LOOKUP("County 3", [County]1:[City]3, 1, false) returns "County 3"
=LOOKUP("County 3", [County]1:[City]3, 3, false) returns "City8"
Can anyone help explain what is going wrong with this formula? I've used the LOOKUP() function before and it works just fine in my other sheets.