Loading....
SIGN UP!
Before you proceed to sign up,
Please select one of the following!
I want to Hire
--OR--
I want to Work as an
Alpesh Portfolio (showing 1 - 1 of 1 results)
  1. »
  2. »
  3. »
  4. Portfolio
PAGE 1 OF 1
SHOW BY
Solving the Problem With Index and Match
Website:
Website Description:
=INDEX($D$4:$D$1000,MATCH(I4,$E$4:$E$1000,0)) The formula looks for the city in column D, in the row where the matching email address was found in column E. Next, I copied the formula down to the last row in the short list, and all the cities showed up in the short list. Finally, I copied the City cells in the short list, and pasted them as values, because the formulas weren't needed any more.
Skill:
Next