you will have to use vlookup I think unless there is another way to do it.