In this video, let’s see how to look up values in another sheet and replace a Product ID with a readable Product Name. We want an exact value and if the value does not exist or errors, we want to return an empty or blank cell value.

I hope this video helps. If it did, please Like the video to save it and so others can find it and Subscribe for more content like this. Let me know in the video comments if it helped and if you have any other suggestions for content.

💸TIPS — You’re never required to leave a tip! If you feel called to, you can use either of the options below. [Thank you!]

Venmo: https://tr.ee/i-8jQchi4N
PayPal: https://tr.ee/Ktw6gMU8iX