Matching Stock from Booking

[htukaram]

Chandu sir

please find the attachment the sample which I highlighted with yellow colours
I use vlookup formula for matching stock with bookings, but there is a issue, bookings 2 with same model & colour, then the vlookup formula match same 1 model to both
please show some formula which can match model & colour with ageing wise

 

[NARAYANK991]

Hi ,

See if this is what you wanted.

Narayan

 

[htukaram]

Dear Narayan sir

First thanks to you,

actualy what i want >

we have car showroom we take bookings from customer.

my task is allocation or matching stock

if customer taken booking then i have to show that vehicle is in stock or not. if yes, stock is there, i mentioned "stock" if not "blank" but customers give same models or colour,

Exp : 1st customer need toyota t1 red (bookings date 01/09/2017) (age 3)
2nd customer need toyota t1 red (bookings date 02/09/2017) (age 2)
3rd customer need toyota t1 red (bookings date 03/09/2017) (age 1)
now
in stock there is two vehicle i have to match with age 1 first then age 2 second.

this is what i want

please help me

 

[htukaram]

sir waiting for your reply

Dear Narayan sir

First thanks to you,

actualy what i want >

we have car showroom we take bookings from customer.

my task is allocation or matching stock

if customer taken booking then i have to show that vehicle is in stock or not. if yes, stock is there, i mentioned "stock" if not "blank" but customers give same models or colour,

Exp : 1st customer need toyota t1 red (bookings date 01/09/2017) (age 3)
2nd customer need toyota t1 red (bookings date 02/09/2017) (age 2)
3rd customer need toyota t1 red (bookings date 03/09/2017) (age 1)
now
in stock there is two vehicle i have to match with age 1 first then age 2 second.

this is what i want

please help me