Wow, that was fast and It worked Great...

I was indeed able to use the Vlookup function to return the values I wanted. I also experimented and discovered that I could use the "&" symbol to link two VLOOKUP functions to return columns 2 & 3 to the same B1 cell.

I had to modify my Data Verification for the A1 cell (appearantly it dosent like multiple columns in the named range) so I simply created another named range.

Thanks again to all.