Forum Discussion
danny1911
Nov 02, 2022Copper Contributor
Excel formula malfunctioning
I am operating on windows 11 and while using the excel app and typing in a formula, the formula replicates itself in another cell. Kindly assist
danny1911
Nov 02, 2022Copper Contributor
Also sorry it’s in .xlsx
NikolinoDE
Nov 02, 2022Platinum Contributor
Are the cells formatted correctly?
here is a small solution (cumbersome, but it works 🙂 , on the fly
- danny1911Nov 02, 2022Copper Contributor
- Patrick2788Nov 02, 2022Silver Contributor
What you're seeing is Excel 'spilling' the results because you're giving IF multiple cells to check.
=IF(A2:A3=List!A2:B2,List!B4,"")
For 1 result, you might use:
=IF(ISNUMBER(MATCH(A2,List!A2:B2,0)),List!B4,"")- danny1911Nov 06, 2022Copper Contributor
Ah ok that will be why, sorry for the delayed response, I have been in music brain for the past few days. Thank you for your help 🙂