Stuck with VBA and data import/lookups on different rows

[mradam87]

Hi all, I'm new here but have been visiting the site for help for a long time! However, I'm really stuck with this one...

On the attached file is an imported data report. Basically, I need to look up the number in the yellow filled cell, and return the value in the red filled cell on another sheet, for each person.

The yellow cell is an employee ID so these will be in a list on another sheet, with the lookup returning the red cell.

The report can sometimes be longer or shorter, but its format cannot be altered. Any vba coding that tidies it up is fine though, as I only need those two bit of data.

Any help much appreciated!

[JBeaucaire]

Possible with a worksheet formula. Just drop the data onto Sheet1 and the list on SUMMARY will fill in.

[mradam87]

Wow thanks, that's brilliant, exactly what I wanted it to do. I think I follow what you've done with the formula too, which is always a good thing

Thanks again!