I have attached my spreadsheet.
Within VB I am trying to do a vlookup on the TB tab column B that finds a value on the same value on the export tab column A and shows the value in column B from the export tab. My VB keeps giving me #NA If I set the column and row it works manually to a specific cell. But I require it to go to to the bottom and lookup each one individually.
Any help would be much appreiated
Bookmarks