I just wanted to create formula which should not change even i have inserted the rows in between
i want to find a value 123 ABC which is A3 value in sheet 1 from constant range(A2:A5) of sheet 2. if it is there in the constant range means it should result as 'X' or 'Y'
But i suppose insert a row in sheet 2 coloumn A4 means the formula in the B2 automatically changes, i have tried to constant the formula but its not helping to acheive this.
See the formula and also attached spreadsheet.
=IF(ISNUMBER(MATCH(A2,Sheet2!A2:A5,0)),"X","Y")
Could any one please help me to acheive this
Thanks in Advance
Bookmarks