Compare 2 columns return different column

[Savage702]

Hi all,

I'm sure this is pretty simple. I have a a worksheet where I'm looking up a users name from one column, finding it in a different worksheet, and if found want to return the office location of that user to the first worksheet.

So far I have this:
=VLOOKUP(D2, Users!C$2:C$404,

I'm working in the E Column.
D = Username
Users!C = Username
Users!B = Location

How do I bring the location over once the username is matched?

Thanks,

Mark

 

[SteveO59L]

In the lookup array, the lookup value must be the first column in the array