I am attempting to put a set amount $ into a column that differs amounts based on type of employee "FT" or "PT". Based on Positions, "A", "B", "C", with value A set to X2, etc - X4. Null for "PT"
I have tweaked it many ways, and have tried the IF nested as well, but the IF nested tells me that I have too many arguments. So I was going with the array and index. I'm thinking that my error is in the range_lookup, however I am out of ideas.
The following is my formula:
=VLOOKUP("FT",[Pay Grade],X2:X4,FALSE="NE")
I appreciate any suggestions.
Bookmarks