On Dec 5, 10:23*am, Freedster
wrote:
OK, combining the names seemed to have worked, and I have the info I need.. *I
did a simple =C2&" "&D2 column on each sheet to append the names together and
then I was able to vlookup() against that for my departments, etc.

I'm still curious though if there's a way to do it without adding columns to
both sheets, though. *No rush. *:)


Try putting that right in your VLOOKUP instead of in a column.