Reverse vlookup

Hello all,

I have a problem while working with Lookup.
Actually i want reverse searching in my table. Details of my problem are given below :

I have a excel table for searching Raw material location in the rack. This location comes when somebody scan the barcode of raw material.
One Raw material (A) is located in 6 locations e.g. 11,12,13,14,15,16.
Second Raw material (B) is located in 8 locations e.g. 17,18,19,20,21,22,23,24.

Now to maintain First in First out, i want that when somebody scan Raw material A first time then result should be 11 after that when scan second time result should be 12 and so on. This will continue till 16 and after that while scan A result should be 11.
Same should be for Raw material B.
Please help me in solving this problem.