How to link one info from one table to another data in another table?

Month Name of Customer Type of Customer Staff Employee No. Airline Tickets Packaged Tour Total Sales Type of Gift
Responsible
$ $ $
Oct-09 Tan Ah Kow #N/A Steven Tan 8888 6500 20000 26500
Oct-09 Safe Enterprise Corporate John Edwards 9999 50000 10000 60000
Oct-09 Alfred Wong Individual Lim Kim Hock 6666 8000 5000 13000




Total Sales Individual Corporate
Less than $30000 Flowers Hamper
>$30000<=$60000 Hamper Watch
>$60000 Watch Cruise


What function do i have to use to link table 2 to table 1 to provide type of gift? Thanks in advance!

If I understand your problem

| A | B | C | D |
1 | Month | Sales | Gift A | Gift B |
2 | Oct-09 | $20000 | by formula | by formula |
3 | Oct-09 | $30000 | by formula | by formula |
4 | Oct-09 | $25000 | by formula | by formula |
5 | Oct-09 | $65000 | by formula | by formula |


the above on first page called Sales
below on second page called Rewards

| A | B | C | D |
1 | upper Boundary | Gift A | Gift B | |
2 | $299999 | Flowers | Hamper | |
3 | $599999 | Hamper | Watch | |
4 | $600000 | Watch | Cruise | |

Put the formula below into C2 and copy it down to C5
=IF(B2<=Rewards!$A$2,Rewards!$B$2,IF(B2<=Rewards!$A$3,Rewards!$B$3,IF(B2>=Rewards!$A$4,Rewards!$B$4)))
Put the formula below into D2 and copy it down to D5
=IF(B2<=Rewards!$A$2,Rewards!$C$2,IF(B2<=Rewards!$A$3,Rewards!$C$3,IF(B2>=Rewards!$A$4,Rewards!$C$4)))

Hope this helps