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)
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.
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.
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.