## Excel find cell address lookup result,cheap cell phone plans with phone,how to track mobile phone using imei number tracking india - .

20.10.2013
Stack Overflow is a community of 4.7 million programmers, just like you, helping each other.
Is there a function I can put in cell A2 that will return whatever is in the cell below whatever cell is written in A1? So for example, if A1 contains =B35 then A2 will return the value contained in cell B36 and if I change A1 to =C17 then A2 will now contain whatever is in C18?
I've been trying to use combinations of indirect(), offset() and address(), but can't figure it out. Assuming your not wanting to do anything more complex than offsetting a single cell reference you could mix in a little VBA.

E107 contains =A100, I want E108 to return the value contained in cell B100, so if I change E107 to =A101 then E108 will now contain whatever is in B101. I'm getting the text of the formula in the cell with FORMULATEXT and applying ASCII operations with CODE and CHAR to add up to A, so that it becomes B, and then returning the value with INDIRECT.
Not the answer you're looking for?Browse other questions tagged excel or ask your own question. What is the name of the (I think) Renaissance harmonic device used in choral music that sounds slightly odd today? That was the first thing I attempted, as it would make the whole thing easier, but short of doing it in VBA, I don't see how.

In this MS Excel tutorial from ExcelIsFun, the 730th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will retrieve the cell address of the minimum value in column. MATCH looks for the string of 255 z's in the column, and in the absence of Match_type 0 (to find an exact match), it looks for the largest value that is less than or equal to 255 z's. It then determines that the last string in the column is the largest value that is less than or equal to  255 z's. MATCH returns the relative position in the Look-Up Array, of the last text value (viz.