• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Code to lookup data and provide set of details based on that

X

xlsvba87

New Member
Hi all

I have a excel sheet in which one of the column(Col E) have employee ID as a lookup value, and in the right end(col AG to AS), I need some basic details about the employee based on the Emp ID in the respective columns. Lookup table is present in another worksheet called "Lookup Table". Now I need a macro to fill in the columns AG to AS by looking up the ID in Col E with "Lookup Table" and provide the results. Also it should do the same till the last row has data in col E.

Note : Lookup Table is not in similar order with our result Col AG to AS. Emp Id is present in col B in Lookup table and data spread across till Col BE in lookup table sheet

Thanks
 
Hi,

Sharing the sample file with expected output would probably yield you quick and precise responses..
 
You must log in or register to reply here.
Back
Top