How to update XML in ntext column?

If & look up (match content in one column with content in another column of another worksheet and update statu?

• One work sheet1 has 2 columns like this.. Alp Status a b c d e f g h i j one more work sheet2 has one column Alp e b d a Each time am entering alphabets in alp(in any order) of worksheet2 the status in worksheet1 should set to "Y" --------------------------------------…

• Answer:

  You're going to need to reference sheet 2 like <worksheet name>:<column row> or something similar. You'll need to check your spreadsheet docs because it will vary from spreadsheet to spreadsheet. As far as what you're trying to accomplish beyond that, you just want to have a formula on sheet 1 that says @if(sheet2:cell < 65 OR > 91, "Y","") where the numbers are your range of ascii conversion and if your condition is true, place your Y in the cell, otherwise leave it blank or whatever you want it to be. It's going to be much easier to check if you've got text there if you convert to ascii values and see if you fall in the range you require. Hope that helps!