thanks i found this =VLOOKUP(LEFT(K5,3),'postal list'!$A$2:$B$51,2,FALSE) basically took the first three letters of list i created.... thanks for the help as wel
thanks i found this =VLOOKUP(LEFT(K5,3),'postal list'!$A$2:$B$51,2,FALSE) basically took the first three letters of list i created.... thanks for the help as wel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks