Return data to "Main Worksheet" from another worksheet with multiple lookup columns

I have searched the database for something resembling my dilemma and was not able to find or associate anything to what I am needing. Any suggestions or help from this forum would be so greatly appreciated.
I have a worksheet called "Main Worksheet in which I am needing to return data to columns L and M based on data in data in columns J and K. Below is a visual of what I am referring to:


Hlookup_search info needed.jpg

Column J Column K Column L Column M
City from Sales Line Item State County Name County Code
OWENSBORO KY
LOUISVILLE KY
FLORENCE KY


The Data I am needing returned is in another worksheet called City_County_Code.
City_County_Code tab.jpg


Since the City_County_Code worksheet has all 50 states listed horizontally across the top of the page and each state contains 3 columns. Each column named under each state is "City", "County", "Code".

I have used Hlookup, Vlookup and Index and Match functions many times before, I am not sure of how the formula should look.


Bottom line....I am needing to have the cells under Column L and M auto populate based on data in Column K and Column J based of data from the worksheet "City_County_Code"


Any suggestions would be extremely helpful in getting this project completed. Thank you.

Thanks for responding so quickly to this...I did consider putting in a vertical mode, I was just trying to minimize the number of rows for the entire worksheet. Not that space is a factor...it is more for the ease of having to work with it when additions need to be made for states that are currently blank. I will try it as a vertical entry and see if I am able to figure out the Index and match function.
With this file going vertical, how would you write the search function?

Thank you again for your very quick response to this.

Thank you for this. I am in the process of changing to vertical and as soon as I am finished, I will try your suggestion. I will let you know soon. Thanks again

Pete