Vlookup multiple rows with the same lookup value

[swesan]

I want to lookup value ie., date(01-06-2013) for which I have stored separate data table in another sheet. For each date, separate data is available. When I lookup the date value, the data table has to be retrieved for printing report. Ex.

Date Unit Wt.in T Earnings Commodity Party

01-06-13 25 1332 2342311 Wheat FCI
01-06-13 42 2342 23423423 Rice FCI
01-06-13 58 3342 234242342 Limestone TNPL

When I look up the date, all other data has to be retrieved in another sheet. Pl. help

Swesan.

[FDibbins]

Hi and welcome to the forum

I would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[swesan]

Hi,

Thanks for your reply. I'm herewith attaching the file for your reference. Pl. see that and suggest good ideas to resolve it.

[FDibbins]

Thanks for the file.

Add a helper column on sheet2 (I used L, you can hide it if you want), and copy this down...
=COUNTIF($A$4:A4,Sheet1!$E$3)
Then on sheet1 A8, copied down and across, use this...
=INDEX(Sheet2!$A$3:$I$48,ROW(A2),MATCH(Sheet1!A$7,Sheet2!$A$3:$I$3,))

[swesan]

Hi,

Thanks for your quick reply. But, I can't get the desired result when I' have copied in my file as you said. What I want is to lookup the data for particular date only. It need not retrieve all rows. Because, for day 1 (1.6.2013, there may be 4 or 5 rows of data. Day-2 (2.6.2013) may have 2 or 3 rows of data. and Day-3 (3.6.2013) may have only 1 row of data and Day-4 (4.6.2013) may have 5 or 6 rows of data. When I change the date in the lookup column in Sheet1, the required data with as many rows for each date needs to be updated in Sheet1. I think You could understand what I'm trying to say. Expecting your earliest reply. Many thanks for your help.....
Swesan