Never mind, turns out it's a limitation of VLOOKUP - the value it checks against must be in the first column.
From: Murray, Mike Sent: Monday, October 10, 2016 4:42 PM To: [email protected] Subject: OT - Excel VLOOKUP help? 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
smime.p7s
Description: S/MIME cryptographic signature
