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

If this post helps click Yes
---------------
Jacob Skaria


"Lise" wrote:

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