i need formula or UDF to fetch data from Adjacent Cell in Table-Source Data and pull it in Table - Output Data as per table-input Data. File is herewith attached for reference.
i need formula in output Table in rates column, which will pull rates from Source table as per the rates which will be entered manually in Input Table. For example in input table Slab Rate has been entered as 35-38-40-42 and rate as 35 on Mon then the rates in output table should show 35 on mon, 38 on tue, 40 on wed and so on. wherever slab rates changes in input data, the output rates should also get changed according to slab rates.