Please how can i copy index of a group of clients from sheet1 to sheet2.
Sheet1 contains Names, Location and Index of the entire clients whiles sheet2 contains only the Names and Location of a particular group.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
IF,THEN
0
Answers
0
Simple Vlookup across sheets.
=VLOOKUP(B2,Sheet1!A:C,3,FALSE)(If this is for homework or a test, future help will only be to point you in the direction of answers instead of solving the problems for you.)