IF formula help

Copper Contributor

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!Screenshot 2024-04-10 at 11.54.34 AM.png

1 Reply


In C4:

=XLOOKUP(B4, $H$11:$H$1000, $I$11:$$1000, "")

Fill down.