Try VLOOKUP
--
Gary's Student


"Rachel S" wrote:

I'm stumped...I need a formula for a Year to date worksheet that references
each MTD worksheet and grabs the most recent value. The only way i know how
to do this is through IF's but the limit won't allow for it. Any ideas?