need help writing formulas.

S

sfnbgirl

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
 
S

Spencer101

sfnbgirl;1612025 said:
Hello,

I would really appreciate some help on writing a formula for th
attached spreadsheet:

I would like for the rows between H to S to be populated by looking u
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 an
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 m
mac.
lookup formula question.zip
Click to expand...

File not attached. :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need help in fine-tuning a formula that removes blank cells in a column range 3
vlookup with two data points. 3
IF statement not returning correct answer 3
VLookup Help 1
Help? I need help in making formulas work to accomplish... 0
Need help in Combining If formula with Vlookup 2
Macro writing formulas 7
My Excel file is not calculating! 13

Top