I'm sure there's an Excel guru out there that can easily explain why this isn't working. In the "testcomp" sheet I'm trying to looking up the distinguished name value on column C to a matching value on the "testuser" sheet and return the friendly user name (or any other columns I choose). It keeps coming up with "N/A", even though the value is there. I've used VLOOKUP in the past a lot, not sure why it won't work here.
TIA! Mike
AD Computer and User Data - TEST.xlsx
Description: MS-Excel 2007 spreadsheet
smime.p7s
Description: S/MIME cryptographic signature
