The Daily Charge is determined by using the Room Number and Rate
Code to lookup the value in the DailyChg worksheet. Use the
XLOOKUP() function with a nested XLOOKUP() function to find the
correct dai
A B 1 2 3 Reservation Room 4 Number 5 R0010 6 R0010 7 R0011 8 R0012 9 R0013 10 R0013 11 R0014 12 R0014 Customer Number Number AL C0001 CA C0001 CO C0002 C0003 FL AL C0004 GA C0004 AL C0005 CA C0005 �