How Can I See if Text in a Cell of Column A Matches Text in Column E and Get A R

Question

How Can I See if Text in a Cell of Column A Matches Text in Column E and Get A Return of the data in Column D of the corresponding cell contained in Column F?

I saw an another question on the site similar with the answer of =IF(COUNTIF(E:E,A1),"YES","")

But not sure how to make it apply to my issue.

I had been using =VLOOKUP(A2,$Y$2:$Z$12,2,FALSE) but only D2 was correct and the other cells in column D were "#N/A"

Thanks in advance for your help!!!

A B C D E F RecNo Name LGL ID RecNo LGL ID 1 Terry,F 1 977945 1 Terry,F 2 968234 2 Smith, S 3 923465

Explanation / Answer

Hi..

=index(F:F,match(A2,E:E,0)).

copy formula down.

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

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