A | B | C | D | E |
Zip | County | Zips | County | |
111222 | Aba | 111222 | Aba | |
111222 | Aba | 111333 | Tauo | |
111333 | Tauo | 111444 | Yap | |
111444 | Yap | 111555 | Rem | |
111666 | Uni | |||
I'm looking for a formula to put in column B to where it looks up the zip code in column A and displays whatever county it corresponds to in column D & E.