Formula to find a Match and return row data to cells.

Hi folks
In the attached Workbook sample I have 2 active sheets, 'Results' and 'Log'.

In Sheet 'Log' Col D I want to look for a match in 'Results' Col B and if a match is found I want to return the corresponding row cell values as shown, into Sheet 'Log'.

So as an example 'Log' D3 has Tom, we search for Tom in Results Col B, a match is found so in 'Log' Tom would have 'L' returned from F2 into I3 and so on.

I have set out the layouts exactly as they will be in the actual Workbook so that I will not have to change the formula's.

Reason for the data not being in the same order on both sheets is that the data is returned from separate programs at different times in different layouts.

Hope that is explained okay.

Cheers
Hammer

there you go

Both brilliant, thank you so very much.

Cheers
Hammer