Forum Discussion
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
Also sorry it’s in .xlsx
Are the cells formatted correctly?
here is a small solution (cumbersome, but it works 🙂 , on the fly
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,"")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 🙂