how to match 2 criteria in marco : I currently have the following codes that look up the column for Columbus. But how do I specify that I only want to look up the column for Columbus in Ohio by also referring to row 4 (State)? 

    Amount = WorksheetFunction.Match("Columbus", Rows("5:5"), 0)
Thank you !