I'm not sure how often you are going to be doing this, but... the quickest might be to copy and paste the three lists into one column. If that is not possible, do a bit of research into the INDEX and MATCH functions, as I think that might end up being the way to go.
Bookmarks