Address cell value(s) to search an aspx site

[excelforumkeys]

Hi Forum...I am trying to search addresses contained in column I on a public county website (http://www.pinalcountyaz.gov/Assesso...celSearch.aspx). I would like to do so by creating a hyperlink formula in column M that populates the address fields of the search site (Number, Direction, Name, Suffix) and conducts the search and pops up a browser with the results. Unfortunately just trying to search the address on the site's general search feature in the upper right does not work. If the solution requires data manipulation such as breaking down the address in to specific cell values, I can probably figure that out (but help there would still be welcomed! ).

Attached is a sample workbook.

Thanks in advance!!!

Chris

[AlphaFrog]

Put this formula in M2 and copy down. It hyperlinks to the property site based on Parcel ID.

=HYPERLINK("http://pinalcountyaz.gov/Assessor/Pages/ParcelSearch.aspx?b="&LEFT(H2,3)&"&m="&MID(H2,5,2)&"&p="&MID(H2,8,3)&"&s="&RIGHT(H2,1),"Parcel " & H2)

[excelforumkeys]

AlphaFrog...I have a similar situation as above, but now I do not have parcel number this time (new sample file attached)...is there a way to search addresses contained in column A on the same public county website (http://www.pinalcountyaz.gov/Assesso...celSearch.aspx)? Again, I would like to do so by creating a hyperlink formula in column B that populates the address fields of the search site (Number, Direction, Name, Suffix) and conducts the search and pops up a browser with the results. Some addresses will not have the suffix available (e.g. AVE or DR) but the search on the site should still work. Note, some addresses might have multiple words between the direction and suffix. Your help is appreciated! Thanks!

[excelforumkeys]

Bam! Thanks AlphaFrog, money as usual!

[AlphaFrog]

Don't have a solution for you on this one. It's a lot more tricky.

[excelforumkeys]

ok, thanks for taking a look! appreciate it