Help with returning next matched value only once.

[airxpress]

Hello,

I've tried to find my answer by reading up on vlookup tables and coming up with the next result but I'm unable to get it to work. I'm sure this will be easy for most of you and I appreciate any help with this.

Essentially all I want to do is return a matching result and then move to the next one. In the example below the column A and D values will be unique, B and C will have some matching and some not.

I want to go down column B and find a match in column C and put output in column E. Once it has already used that match it found in column C I dont want to return that result ever again as its already used. How can I get it to return the next result and it no matching results it returns None?

I got this so far, obviously it doesnt move onto the next match after its been used.

=IFERROR(VLOOKUP(B2,$C$2:$D$13,2,FALSE),"None")

old dev old size matching sizes new dev lookup result
0061 43706 43706 111 111
0062 43706 43706 222 111
0063 43706 43706 333 111
0064 43706 163840 444 111
005C 163840 163840 555 444
005D 163840 163840 666 444
0050 559264 163840 777 999
0054 559264 163840 888 999
038B 600296 559264 999 None
038C 600384 559264 a46 None


Thanks again

 

[airxpress]

file attached if thats better

 

[prasaddn]

Hi,

Pls also include the expected output manually, so that it will be more clear.

Regards,
prasad DN

 

[airxpress]

file with expected output attached. Thanks

 

[Pavan.Sada.PS]

Hello Airxpress,

Plz look at the attached file.. I have used the helper column to achieve the expected results.

Regards,
Pavan S

 

[airxpress]

Thanks Pavan!

 

[John Jairo V]

Hi to all!

Another option without Helper Column.

Please Comment!
I hope it helps! Blessings!

 

[airxpress]

Thanks John, great work!