Dear all
I have a queries in Lookup in two tables
Table 1 - I got some data but with a missing "Selling" , it is same in Table 2
Table 2 - it has the selling and the common file with Table I is the Booking and REference
How I can looking up the "Selling"in Table 2 from Table 1
Thanks for helping
Booking No Services Pax Selling
Table 1 1 Apt - Hotel 2
1 Hotel-Apt 2
2 Apt - Hotel 2
4 Apt - Hotel 2
5 Hotel-Apt 2
6 Hotel-Apt 2
7 Apt - Hotel 2
Table 2 Reference Services Selling Costs
1 Apt - Hotel 100
1 Hotel-Apt 150
2 Apt - Hotel 100
4 Apt - Hotel 100
5 Hotel-Apt 150
6 Hotel-Apt 150
7 Apt - Hotel
Eric , sorry, the attached file function not working
Bookmarks