OFFSET trouble

[MI man]

Hello....ppl..!!

Somebody please tell me what OFFSET does...

I have some problem....

Have data (say column 1 has codes, each code would have multiple data in another column (column B) and each entity of column B has multiple (and sometimes redundant) data in column C.

I have used OFFSET to refer to column B through A and C through B and it's working fine.

However, I tried a little reversal of it...say, tried referring Column C through Column A and Column B through Column C.....but the data is not correctly retrieved this way...


Note: Column B is a concatenation of Column A and Column D

Any help..!!!

 

[lemo]

maybe try using negative numbers? e.g. using -1 for rows will send you one left..
here is useful simple explanation of Offset -
http://blog.contextures.com/archives/2010/01/20/something-fishy-using-the-excel-offset-function/

l