i have data like this in one sheet
no tt sa
654 1415 1000
655 1416 2000
656 7415 3000
and data in sheet2 like this
tt bonus
1415 500
1416 600
1417 700
7415 800
7416 900
what i wnat is the formula to be used to have data like this
no tt sa tt bonus
654...