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
A little more information would help to be able to suggest a solution to you.
Welcome to your Excel discussion space!
Additional information such as Excel version, storage medium, what formula it is, what form of Excel file it is (.xlsx, .xlsm, etc.), a file (without sensitive data) or photos, certainly help.
Thank you for your understanding and patience
I know I don't know anything (Socrates)
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,"")