Vlookup in a list that the 3rd number changes


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. 



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: 1521) Dec 10, '16 at 4:34 am
Add to Discussion



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.


Answer the Question

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