Dec 04 2021 06:53 PM
Dec 04 2021 10:18 PM
@1776memb Please have a look at the attached workbook which contains a very basic example. It's not as straight-forward as you might have thought. VLOOKUP returns a value from a range when it finds a match or an #NA error is it doesn't. Now you want to "translate" these to "Completed" and "Not completed" respectively. So, you'll need to include IFERROR and IF.
The workbook also includes an example using MATCH, rather than VLOOKUP. And, depending on your Excel version, you may want to look if it supports XLOOKUP, a more powerful and flexible lookup function.
Dec 05 2021 08:51 AM