I have always used concatenate to do a lookup on multiple fields, however, today I saw someone use an Index and Match to find two different fields of data. I am not quite there yet, so I was wondering if someone could help me with the data in the workbook to fill in the missing formula.
it's array formula you have to hold down ctrl+shift+enter not just enter
=IFERROR(INDEX(Data!$E$2:$E$25,MATCH(After!A3&After!B3,Data!$A$2:$A$25&Data!$B$2:$B$25,0)),"")
-> if done right the formual would be enclosed with curly {} braces
becomes
{=IFERROR(INDEX(Data!$E$2:$E$25,MATCH(After!A3&After!B3,Data!$A$2:$A$25&Data!$B$2:$B$25,0)),"") }
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
hi greggpetersen75. as an alternative, try this in C3:
=SUMIFS(Data!C$2:C$25,Data!$A$2:$A$25,$A3,Data!$B$2:$B$25,$B3)
if you don't want to see zeros, try:
=IFERROR(1/(1/SUMIFS(Data!C$2:C$25,Data!$A$2:$A$25,$A3,Data!$B$2:$B$25,$B3)),"")
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks