Hello
could you please help me I need a forumla that uses a vlookup to find multiple results for the same part i.e
I have parts that appears more than once all for the same Qty
<TBODY>
</TBODY>
on another sheet i have the follwoing
<TBODY>
</TBODY>
what I would like is a vlookup to return the first result then for the second return the second result and so on?
I hope this makes sense.
cheers
could you please help me I need a forumla that uses a vlookup to find multiple results for the same part i.e
I have parts that appears more than once all for the same Qty
part | qty | date |
apple | 100 | |
apple | 100 | |
apple | 100 |
<TBODY>
</TBODY>
on another sheet i have the follwoing
part | qty | date |
apple | 100 | 03/05/13 |
apple | 100 | 16/05/13 |
apple | 100 | 23/05/13 |
<TBODY>
</TBODY>
what I would like is a vlookup to return the first result then for the second return the second result and so on?
I hope this makes sense.
cheers