Vlookup function

[Latha]

hi,

i have 2 sheets with columns(column A) containing e-mail addresses

for example : shee1 - column A (e-mail address), column B (user ID's of respective people)

Sheet2 - column A (e-mail address).

Sheet 1 consisting emails and user IDs of all employees of the organisation.
Sheet 2 consisting emails of only managers

i want to compare both columns containing emails and return the relative User ID of the manager.

please help.

 

[Latha]

please revert soon

 

[mrMozambique]

Put this formula in cell B1 (assuming your data starts there) of Sheet2.

=VLOOKUP(A1,Sheet1!A:B,2,FALSE)

 

[Latha]

Thank you so much. it is working fine.

Thank youuuuuuu

 

[Latha]

hi,

Thanks for the help.

could you please explain the formula that you have shared? how it works?

i need to work with vlookup in further days.

so please guide me.

 

[mrMozambique]

contextures is much better than I am at explaining such things:

http://www.contextures.com/xlfunctions02.html