I have a complex Find scenario. I have 2 worksheets.

In WKSHT 1 I have a list of alphanumeric values in Column C that I would
like to find in Column E of WKSHT 2. When found, I would like the value in
the same row on WKSHT 1 in Column J to be pasted into a the cell in WKSHT 2
in Column A, 4 rows down from where the alphanumeric value was found. I also
would need it to paste a second value from WKSHT 1 in Column H into WKSHT 2
Column J.

Does that make sense?

I have example worksheets that I can email.

The number of rows in WKSHT 1 is variable, usually ranging from 3-100 and
would like for it to automaically search for the entire list.

Thanks for any help that you can offer.