Put the concatenated officer's name to the left of the columns you want to look up and the VLOOKUP should work (attached). If that looks like it works, maybe I can dive in further.
I like how you've made good use of named ranges and even the Format as Table functionality, at least for the table on the Officer List tab.
|