Trying to figure out the right formula for the following sheet. Basically I want to search the B column for specific names, if they exist, I want the corresponding row C cell to reflect the "Pay" pulled from the key in column I. Any help is greatly appreciated!
