Matching values from 2 columns and returning the value in 3rd column

Shaz_79,

Unfortunately, I do not keep example workbooks, I delete them at the end of the day (this is because I am mainly on this forum from my work computer, during times that I am in between assignments). With the recent upgrade to the vBulletin version this forum uses, the attachment database got corrupted. This means that all of the attachments shown in this thread are not what they originally were.

I was going to use your original attachment to recreate the example, but I am unable to for the above reason. If you could repost it, I would be happy to recreate the example for you.