Hi, I have written a macro that performs a vlookup. Originally, the column of data that vlookup uses was soley numerical, however, now, I need it to be a text column (with some numbers and some text). From my reading, it seems that vlookup should still work, however, it is not working. Does anyone have any suggestions.