You have to keep your data somewhere. If you do this with a macro, hard-coding all the data pairs and some of your value pairs change, then you'll have to edit the macro. Embedding all these pairs into a formula would be even less maintainable. You don't have to have the table on the same sheet. It can be on a hidden sheet, or in another workbook alltogether, FWIW. Vlookup works with closed workbooks, too!