Good afternoon. Due to the limitations of VLOOKUP I need an alternative formula

Question

Good afternoon.

Due to the limitations of VLOOKUP I need an alternative formula combination to insert data from one worksheet to another worksheet. I have read about INDEX & MATCH, however, I am unable to implement.

This is my environment:
-Excel 2013
-2 worksheets within the same workbook
-Data has been "formatted" as Tables

Worksheet 1 contains store contact info with these columns: Address City State Zip County

Worksheet 2 contains county data with these columns: State City County

Requirement
Within worksheet 1, I want to create a formula in the County column to pull the county data located in worksheet 2, using the city in worksheet 1 as the criteria for determining the correct county.

Thank you in advance for your assistance.

Explanation / Answer

Try this one,

=INDEX(Table2[County],MATCH(1,INDEX((Table2[State]=Table1[[#This Row],[State]])*(Table2[City]=Table1[[#This Row],[City]]),,),0))

Related Questions

Navigate

• Browse (All)
• Browse G
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.