Help please Thank you

Discussion in 'Off-Topic Discussions' started by Phdtobe, Apr 23, 2013.

Loading...
  1. Phdtobe

    Phdtobe Well-Known Member

    Degreeinfoers, I need your help in decoding this excel formula. The formula is in J156 of a spreadsheet. I am familiar with Vlookup but at the basic level. Your help is greatly appreciated


    =VLOOKUP(LEFT(A156,LEN(A156)-2),compensation,MATCH(RIGHT(A156,2),SALSEC)+1, FALSE)
     
  2. AUTiger00

    AUTiger00 New Member

    the lookup value is LEFT(A156,LEN(A156)-2) (the "-2") just knocks off the last 2 characters/digits in A156.
    MATCH(RIGHT(A156,2),SALSEC)+1 is the column number to look up and FALSE means to find an exact match.
     
    Last edited by a moderator: Apr 23, 2013
  3. Phdtobe

    Phdtobe Well-Known Member

    I thank you very much for your response. From my research and your help I’ve able to understand portion of the formula, but I am not sure what the whole thing put together is saying.
    Is SALSEC and excel formula? I can’t seem to find SALSEC as a FIELD in the spreadsheet.
    Is compensation referencing a field, an array, or a spreadsheet?

    Thanks for your help.
     
  4. AUTiger00

    AUTiger00 New Member

    I don't know what SALSEC is, but it's not an excel formula/command. My guess would be that "compensation" is a field or column in the spread sheet. I would think it would be the final two columns of the spreadsheet as that is where the formula is being asked to search.
     
  5. Phdtobe

    Phdtobe Well-Known Member

    Thank you so very much
     

Share This Page