• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 186
  • Last Modified:

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
0
bsharath
Asked:
bsharath
3 Solutions
 
Rory ArchibaldCommented:
Why not just use VLOOKUP formulas in sheet 1 to get the data from Sheet2?
Regards,
Rory
0
 
KCTSCommented:
A vlookup is the solution see http://www.contextures.com/xlFunctions02.html for a woal through of how to use this function.
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

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now