Hello all,

I'm working on an excel sheet that will extrapolate data from a
roster.

The idea is for when the name is entered, the corresponding shift and
location is automatically populated in to the field.

The crux of the problem lies in the lay out of the data is necessarily
stacked, Shift on one row, Location on the second row. Extracting the
row is a cinch, a simple Vlookup. THe problem comes when I try extract
the corrolating Location below it, I can't. I've tried the Offset
function, but I can't seem to get it to work for me, I won't accept
dynamic references.

There's probably a very simple Macro for it, but my skills aren't
advanced enough to dabble into the creation of my own macros..

Any assisance would be very much appreciated, I'm tearing my hair out
from this one.

Michael J. Lockwood


--
Michael Lockwoo


------------------------------------------------------------------------
Michael Lockwoo's Profile: http://www.excelforum.com/member.php...o&userid=31811
View this thread: http://www.excelforum.com/showthread...hreadid=525979