In sheet “Data” I have my actual data.
Column “A” is a Serial number, Column “B” is a Code, Column “L” is the Size, Column “M” is the “Category” and Column “N” is the “Fees”
In Sheet “Fees”, I have Fees table.
In Column “A”, I have category, which is mentioned in column M of Sheet “Data”.
In Row number 2, band of size mentioned which is available in Column L of Sheet “Data”.
From Row number 3 to 16, given a fees applicable against respective category and size.
I need code for below task.
In sheet “Data, Insert fees in column “N” as per the Size mentioned in Column L. Have to fetch the fees from Sheet “Fees”.
For Examples in first row size is 75 and Category is 200000. The size 75 is falls under Size band of 71-75.
Hence the Fees against category of 200000 and size band of 71-75 is 9,887.
in Second row size is 67 and Category is 300000. The size 67 is falls under Size band of 66-70.
Hence the Fees against category of 300000 and size band of 66-70 is 12576.
Like wise have to fetch applicable fees in Column “N”.
Incase the Category mentioned in Column M is Not available in Sheet “Fees” Insert String “Category Not Available”.
For example, please refer Cell N12 . Here the Category mentioned is 4500000, which is not available in sheet “fees”.
Bookmarks