Excel VBA Course
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.)

View Course

Vlookup in a list that the 3rd number changes

0

My list is our position numbers.  These position are broken out by levels.  The third number changes dictating the level.  My goal is to efficiently bring the levels together across the spread sheet  to verify that each number exit for each level.

I have attached my spread sheet and did the first few manually to show what I am trying to achieve. 

Answer
Discuss

Discussion

So you want to return the description using a vlookup? Sounds like you need to learn how vlookups work and go from there.
don (rep: 1989) Dec 10, '16 at 4:34 am
Add to Discussion

Answers

0

I need better understanding of the problem. (I'm not getting it from your brief explanation.)

But, you may need a vLookup and perhaps a Pivot Table to assist you.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login