I need to lookup data in a report and pull it into an excel document so that I can better manipulate the info. I need to find data at an intersection based on info in two columns and a single row. I have attached a sample of what I am trying to accomplish. I need to pull data from the report tab based on data in the Location and Act Desc columns based on the date in row 2 and populate the info in the Lookup tab accordingly.
I believe that I will need to use a combination of formulas, but I am unclear how to nest or even go about this solution. Any assistance would be greatly appreciated!
Try:
=IFERROR(INDEX(Report!$D$3:$G$10,MATCH(1,INDEX((Report!$A$3:$A$10=$A2)*(Report!$C$3:$C$10=C$1),0),0) ,MATCH($B2,Report!$D$2:$G$2,0)),"")
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks