Hello, Sample file attached.....I want a macro to search discount % in another data table with Discount based on days as 'Y' and 'N'. If it is N, then the discount% is based on this data table only. If it is 'Y', it will also depend on main table on the left.
The result as displayed in yellow... First,the discount% shall be as per 'Nature' column from the table on right irrespective of ID and days.....
after that, the result shall contain the maximum discount% based on ID or Deal....otherwise the cell shall remain blank....
thanx in advance....
Bookmarks