Monday, February 4, 2013

yogi_Set Up Table For Total Salary By Associate And LookUp Contribution By Employer And Associate


                                          Google Spreadsheet   Post  #1010
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Feb 04, 2013
post by user: Rajiv Rai Singh said:(http://productforums.google.com/forum/?zx=fd3vq3iqu592#!category-topic/docs/spreadsheets/foraHR1-Z_U)
How to have a cell select the right value based on a list 

I have a list that states a range. Like in the attached "sheet1.pdf"

I have another sheet that calculates the total salary of the employee. I then need to call on sheet1.pdf to display the right provisions based on which range the employees total salary falls in. Like in attached  "sheet2.pdf" 

I have research vlookup and if formulas but cant seem to wrap my head around it, I could really use the help.

Thanks
Attachments (2)


Sheet1.pdf
21 KB   View   Download


Sheet2.pdf
31 KB   View   Downlo















---------------------------------------------------------------------------------
following is a solution to a bit more generalized problem
 

3 comments:

  1. Hi thank you Yogi Anand,

    Just to clarify some parts:

    1. When you say A2 in front of the A "A2:A. Am I right to say that the A2 defines which row the value starts from?

    2. The 1st part of the formula =ArrayFormula(ifA2:A="","",. What does the "" define?

    3. What if I am breaking my associate's based on each sheet. In other words each sheet represents an associate and the rows represents the different months. Example:

    Beth:

    JAN
    FEB
    MAR
    ...

    ReplyDelete
  2. Hi Rajiv:

    1. A2:A defines a range starting from row to of column A to as far column A extends in the sheet
    2. "" stands for blank
    3. Share your Google spreadsheet explaining what you are trying to accomplish, show your expected
    results along with needed logic/explanation
    and then let us take it from there.

    Make It A Great One.
    Cheers!
    Yogi
    Cloud Computing -- Google Docs Way
    yogi--anand-consulting.blogspot.com

    ReplyDelete
  3. Hi Yogi, I have shared the link to the sheet in the group forum.

    ReplyDelete