Quote Originally Posted by Dave H9 View Post
Not sure how big your lookup list is but please see if you can adapt the attached

Dave H
Yes, an iterative approach using composite IF functions.

Unfortunately, with all the additional Lookups we will adding, this could get very awkward. Is there anyway to automate the process such that it
will continually cross check down the entire lookup table until a match is found, and if non are found the the process stops?

Your thoughts thanks