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