To insert code automatically on sheet with crossm atching main database

[RAM72]

Hi All

As per annexed .

Need help have a main database (sample) and a worksheet(sample) but have to insert code manually.

Looking for a formula to fill column code automatically in insert code sheet with reference fileld stock no and unit .

However the sequence no in insert code should remain same .

Thanks if a solution could be found .

 

[Debraj]

Hi Ram..

Try this formula in Inser sheet .. B2

=INDEX('Main Database '!G$2:G$324,INDEX(MATCH(C2&F2&G2,'Main Database '!B$2:B$324&'Main Database '!E$2:E$324&'Main Database '!F$2:F$324,0),,))

 

[RAM72]

Hi Debraj

Tried your formula works marvelously.

Thanks you a lot for your invaluable help

Regards
Ram