Hi there and welcome
You would achieve this in Access as this is specifically what access is designed to do (database storing and query / reporting).
Is this all you needed to know?
But its being done in Access, what is needed from Excel?
You mean you just want the query in access right?
ok, do you have the Excel and Access file so the formulas can be made?
Can you attach them to this question please. Use the Attach File button
thanks, ***** ***** need your Access File but I did the Excel for you here
How did you gi with it? As I never heard back from you once I gave you the answer.
ok, I did it for you, it is available on the link I gave.
please just wait a minute and ill explain it....
Its using a vlookup to get this information and you can see the formula being used
The first part is the criteria, so it is referencing the ID as what to actually find
The second part of the formula is where to look, and you include all columns starting from where the ID is till you reach the column to return the data for.
Then 3rd part is what number column to return from the range in the second part of the formula
The last part is if the formula can match an approximate match or an exact.
I still do not have the access file from you so cannot do this until you provide it via http://ge.tt
I do not know what your looking at, but its not the file I gave you, as the first row in results has the data, and the following rows the formula.
But you can contact customer service for your refund.
Then your not looking at the file I gave you, as its there, 100%, downloaded it again from my link and confirmed. But I thought you now did not want the formula but the explanation about it which I provided you before when asked?
Anyway, no problem, you can contact customer service for the refund your requesting.
Thanks and all the best
No problem at all.