I need to display mutiple results from a V lookup. Please excuse my
explination, I am trying my best!

I need to look up the due dates of products into our warhouse, in some cases
there are multiple results.

On Sheet 1 in column A I have the product codes I need to look up.
On Sheet 2 I have the product codes in column A and the due dates in column B.

I need to display the correesponding due dates in column I (for the 1st due
date), column K (for the 2nd due date - if applic.) and column M (for the 3rd
due date - if applic.).

Is there such a formula?

Hi Nikki,

See the attachments to my posts at:
http://www.techsupportforum.com/micr...la-issues.html

--
Cheers
macropod
[Microsoft MVP - Word]


"Nikki" wrote in message ...
I need to display mutiple results from a V lookup. Please excuse my
explination, I am trying my best!

I need to look up the due dates of products into our warhouse, in some cases
there are multiple results.

On Sheet 1 in column A I have the product codes I need to look up.
On Sheet 2 I have the product codes in column A and the due dates in column B.

I need to display the correesponding due dates in column I (for the 1st due
date), column K (for the 2nd due date - if applic.) and column M (for the 3rd
due date - if applic.).

Is there such a formula?