Reply to thread

Message: [QUOTE="sfnbgirl, post: 7418670"] Hello, I would really appreciate some help on writing a formula for the attached spreadsheet: I would like for the rows between H to S to be populated by looking up the table on sheet 2. I have populated 2 of the rows as examples. Where the ramp % numbers need to start depends on the effective date and also whether the person is a new hire or transfer. Not sure whether to use vlookup or if statements, help! Not sure if I am attaching this appropriately as it looks weird on my mac. lookup formula question.zip [/QUOTE]