Trying to lookup a cell reference where the result vector will have one or more results.

Hi guys,

I'm trying to lookup a cell reference where the result vector will have one or more results. I have two (2) data sets where I am trying to match one (1) column in each of them to each other and then display my results from a third column. For example:

'Sheet1'!A2:A134 and 'Sheet2'!A2:A256 have corresponding numerical identifiers in the cells and 'Sheet2'!J2:J256 has the results that I wish to display.

The problem I have is that 'Sheet2'! obviously has more cells and therefore a simple lookup function does not work. What happens is that the results keep displaying further and further down the page instead of stopping at the row they correspond to. For example:

What needs to happen - 'Sheet1'!A2 corresponds to 'Sheet2'!A2 corresponds to 'Sheet2'!J2
What is happening - 'Sheet1'!A2 corresponding to 'Sheet2'!A3 (or even further down) corresponding to 'Sheet2'!J3 (or even further down).

The current formula I have looks something like this - =LOOKUP('Sheet1'!A2,'Sheet2'!A2:A256,'Sheet2'!J2:J256).

Could anyone please tell me one of the following things:

1 - Instead of the formula having a meltdown whenever there are more results than lookup values, how can I get it to stop at the first or (more importantly) the latest result due to the fact that they are all date and time stamped?

2 - Is it possible to have the second, third or fourth reference from the result vector displayed across different columns, rather than just having it stop entirely?

I'm hoping the amount of detail in this question doesn't put anyone off answering.
Please help! I need desperately.

Dan

Hi Glenn,

Please see attached example. My original message should spell out what I need.

Dan