I have a colum which has Employee Id's listed in a excel.

Hi,

I have a colum which has Employee Id's listed in a excel. I need a macro to query with another sheet in the same excel and get me all the adjacent details of the employee id to sheet 3

EX;
In sheet 1 i have
Emp ID
In sheet 2 i have
Emp id Name Age  City Country
So in Sheet 3 i should get
Emp id Name Age  City Country

Regards
Sharath
LVL 11
bsharathAsked:
Who is Participating?
 
Brian PiercePhotographerCommented:
A vlookup is the solution see http://www.contextures.com/xlFunctions02.html for a woal through of how to use this function.
0
 
Rory ArchibaldCommented:
Why not just use VLOOKUP formulas in sheet 1 to get the data from Sheet2?
Regards,
Rory
0
 
nike_golfCommented:
Rory's correct.

A Vlookup would would nice for that something like Vlookup(EMPID, RANGEtoSEEK, COLUMNofRESULT, FALSE)

From the help - VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

NG,
0
 
bsharathAuthor Commented:
Can any of you help me with a Macro to do it
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.