Power Query
Power BI
May 30, 2015
Hi Excel Geeks
I am trying to match the first name and surname on one list to a second list of names and if they match to select the cost against the matched name from the first list and add it to the second list - I have attached a sample file to clarify what I am trying to achieve.
The difficulty I have is when two or more people have the same first name - combining the surname has given me an error message and I cannot spot my error.
Please can you help!
Regards
Mel
VIP
Trusted Members
June 25, 2016
VIP
Trusted Members
June 25, 2016
Hi Mel
Just wrap your formula with =IFERROR(Your formula,0).This will display a 0 if the formula evaluates to an error.
Example =IFERROR(INDEX('List of names with costs'!$E$5:$E$9,MATCH(1,INDEX(('Names to match and add costs'!B3='List of names with costs'!$B$5:$B$9)*(C3='List of names with costs'!$C$5:$C$9),0),0)),0)
Hope this helps.
Sunny
1 Guest(s)