Function to match two values one in row, another in column

Hi there!

My puzzle is to list revisions of multiple documents by date. I have three columns with number, revision and date that it's been issued.

With the help of pivot table, i sorted numbers in column and dates in a row and now need to show on what date what revision was issued.
Unfortunately pivot table lists just number, not the revision name itself. so instead of "AB" or somthing, it gives only "1". which is not good enough

It's not a terribly big table - only 38 dates and 2000-ish documents with multiple revisions.

I guess that it would be two criteria function - if or vlookup and match?

Please HELP!!!

Lina

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Sorry, forgot to attach the example.

In B2

=IFERROR(INDEX('sorted data'!$C$2:$C$586,MATCH($A2&DATEVALUE(B$1),'sorted data'!$A$2:$A$586&'sorted data'!$B$2:$B$586,0)),"")

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Copy across and down

WOW... Thank you very much! All is working. How did you learn all that?

Most of what I now know about Excel has been learned via this forum by reading posts and then lots of practice!

Equally there are many sites on the Internet providing Excel education, especially on YouTube.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.