Return Headers Based On Two Values

Regards All,

I am working on Vendor Rebate Schedules and I need to somehow translate vendor's schedules into our own upload-able schedules for purchase systems. I need to return Months based on two values ProductCode and Percent available for those months. Attached file has two tabs VendorSchedule and InternalSchedule and I need to return Months on the InternalSchedule.

Thank you all.

Hi just2cruz,

Try the attached sample. I moved the vendor version to the Internal tab just for ease of setting it up. Maybe too simple but maybe enough. You may have to copy - paste special to remove the formulas before you upload it. if the form is constant from each vendor, I suggest making a vendor master worksheet where you can paste their info into a tab and the result is available for copying into your upload form. This keeps you from re-making the result formulas.

Enjoy,

T

Hi tandwfund,

Thank you for your response.

What formula do I need to use to return those values in Months for InternalSchedule? The files I get from the vendors have 1000's of items and I need to return values in Months the way it's shown in InternalSchedule. I am trying to work with Index Match functions but cant seem to get it right because we have only six columns (1 column to squeeze two months) to upload with.

Regards

write at C3 sheet internal header
=IF(LEN(VendorSchedule!C3),VendorSchedule!C$2,"")

drag right and down

Hi Ghozi,

Thanks for your help. How can I do the same using Match and Index function? I need to return headers based on two values ProductCode and Rebate %.

send me sample attachments to understand you meant

Hi Ghozi,

Attached sample has two tabs VendorSchedule and InternalSchedule. For the InternalSchedule, I need to return Months based on two values in VendorSchedule - ProduceCode and Percentage for those months. I am looking to work Index Match formulas so that I could return based two values.

Thanks Again.