Copy specific cell using Multiple criteria

[Lise]

Hi

I have a sheet with 8 columns of various information - if whatever is
written in A1 is listed in anywhere in Column F2:F720 (say F600) I want the
corresponding cell (E600)in the e column to show

I have tried a few ways but seem to missing a vital part.

Any assistance as always appreciated

Thanks

 

[Jacob Skaria]

Try
=INDEX(E2:E720,MATCH(A1,F2:F720,0))

If this post helps click Yes