Forum Discussion
Ellen Class
Jun 18, 2018Copper Contributor
Match names between two sheets and return value of a cell in the row
Hi there: I am tracking forecast and actuals for various projects and vendors (example attached). I'm looking for a formula to compare the projectname, services co. name, month and year on dif...
SergeiBaklan
Jun 19, 2018Diamond Contributor
Hi Ellen,
For that sample
formulas in column E could be
=IFERROR(INDEX(Table1,MATCH(1,INDEX((A7=Table1[One])*(B7=Table1[Two])*(C7=Table1[Three])*(D7=Table1[Four]),0,1),0),5),"")
Please see attached.