Hi,
I could easily create the lookup formula for you. I've been working with Google Sheets for over 5 years now and I know most of the strategies and formulas within the platform. Please don't concern yourself with the 30 usd. I'm still not quite sure what the project details are so I simply placed the rate at a safe level. If the project is a lot easier than expected, then I would happily bring it down to a comfortable budget for you. If you'd like to know more about me, please feel free to send me a message. I would really love to work with you soon.
Regards,
Rich :)