VLOOKUP can be nested or used with IF to accommodate multiple lookups. From: [email protected] [mailto:[email protected]] On Behalf Of Murray, Mike Sent: Monday, October 10, 2016 6:00 PM To: [email protected] Subject: [mssms] RE: OT - Excel VLOOKUP help?
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]<mailto:[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
