Displaying Multiple Results from Vlookup

N

Nikki

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Making a table for multiple sheets Excel 2007 2
vlookup with if statement together 6
counting, multiple conditions and results 1
vlookup with two data points. 3
conditional formating dates, please help me 1
Complex Look Up (amended) 2
Count if using multiple date criteria 4
Calculating Days Late 1

Top