vlookup based on certain text

I've been trying to use V-lookup to solve this issue, but have not been successful. I have a cell with a string of text and numbers, and I want to look at only the last the 3 characters, search in an array, and return a value in the next column. Here's the example

PWREM-02140-100 I want to look up the last 3 characters, 100 in this case (the last 3 characters will be different for each cell), then look up that value in a table, and return the value in the column next to it. In this case, it should return, Owner's Team

100 Owner's Team
110 Labor
170 Travel & Expense Account
180 Project Assurance Workshops
190 ProCard Account
970 Contingency
980 Allowances
999 General & Administrative

If you are using the RIGHT function to extract the last 3 characters, you need to be aware that those characters will be text values, but your lookup table probably has them as numbers. You can put VALUE( ... ) around the RIGHT function to convert them to proper numbers (there are other ways as well).

Hope this helps.

Pete

Perfect, the adding "Value" did the trick. thank you!