C
Caligula
When using the lookup function, the value from where Column X (assumin
the value is found at XA) and Row N intersect is returned. I'm lookin
for a way to return the value of a cell two cells to Column X's righ
(in this example, would be ZN). There is no way to use the looku
function to return this value, as cells XA, YA, ZA are merged. The onl
way to do this (that I can think of) is to return the reference of wher
Column X and Row N meet to use an offset function to return the value o
the cell two columns to Column X's right (value of ZN). Is this possibl
or does anyone know another way to do such a thing? Any help would b
greatly appreciated
the value is found at XA) and Row N intersect is returned. I'm lookin
for a way to return the value of a cell two cells to Column X's righ
(in this example, would be ZN). There is no way to use the looku
function to return this value, as cells XA, YA, ZA are merged. The onl
way to do this (that I can think of) is to return the reference of wher
Column X and Row N meet to use an offset function to return the value o
the cell two columns to Column X's right (value of ZN). Is this possibl
or does anyone know another way to do such a thing? Any help would b
greatly appreciated