As a Florida resident, I have to point out that Florida is a yellow dog state. 'scuse me, a yaller dog state.
I might approach this in a couple of ways. If I'm always searching for the same keys, and especially if the table is large (hundreds or thousands of rows), I would create a hidden column which concatenates all the key columns. Then I'd use Match to search that column for the combined key value, and use the returned value to Index the row of the table. (You could also use Vlookup in this case, by placing the hidden column to the left of the table. However, that requires using Vlookup once for each value you want to retrieve. Match is better for retrieving multiple values.)
If the search is complex -- for example if the user is allowed to specify any combination of one to four columns to use as search keys -- then I would go into VBA and write a loop to go through the table. This will probably perform fine for hundreds of rows. If the table gets into thousands of rows and the search is getting executed constantly (IOW not just when the user punches a button), then performance might be slow. In that case you would need to reconsider how to store and search the data.
Edward
PS: I don't doubt AhoyNC's proposal, but making changes to it -- for example, using a different number of key columns, or even adding rows to the table -- will require understanding what has to be changed. It does avoid VBA and hidden columns.
