this is the table: Results go here:
11/19/08 11/20/08 11/21/08 Truck Appointment
8:00 AM Truck1 Truck4 Truck9
9:00 AM Truck8 Truck5 Truck1 Truck1 11/19/08 8:00 AM; 11/21/08 9:00 AM <-- This is result but when time is entered as a time not as text (')the
10:00 AM Truck9 Truck11 Truck5 Truck2 result is shown as decimal (.33333333 for 8:00 AM and .375
11:00 AM Truck6 Truck4 Truck2 Truck3 for 9:00 AM).. The dates are fine. They calculate perfectly.
Function RL(truckvalue as range,lookuptable as range)
hrow = lookuptable.rows(1).row-1
hcol = lookuptable.columns(1).column-1
RL = ""
for each cell in lookuptable
if cell.value=truckvalue.value then
RL = RL & cells(hrow,cell.column).value & " " & cells(cell.column,hcol).value & ";"
All of this in straight from Dueling Excel with MrExcel & Excelisfun episode Reverse Lookup (trick #7)
sorry this didn't turn out.. Wont let me paste it from excel (2010)