• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Fetch Data from adjacent Cell

nkms143

Member
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.
 

Attachments

  • Source Data.xlsx
    10.8 KB · Views: 0
Hi nkms,

I'm afraid I don't follow the logic, as to which tables feed which, or even what cell(s) is needing to have a formula. Could you elaborate?
 
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.
 
Back
Top