Calculator End Of Warranty Date Based on Company Name

[mr_ITtoyou]

We have different companies that offer different amounts of days on their warranty. Company ABC offers 90 days warranty on their products, Company XYZ offers a 730-day on their warranty. How would the formula be setup using the companies name in cell A1, then in cell A2 the purchased date 3/21/21 add 90 days that display the end of warranty date on cell A3?
A1 A2 A3
ABC 3/21/21 6/19/21

B1 B2 B3
XYX 3/21/21 3/21/23

 

[jtakw]

You're welcome, thanks for the feedback.

INDEX/MATCH can do a similar job as the VLOOKUP, but I don't particularly see any advantage for this situation.

BTW Don't forget to mark the post that answered your question as solution.

 

[mr_ITtoyou]

Opps! Thanks You

 

[jtakw]

mr IT, for your reference, here's why and how:

Mark as Solution

The helpers at the MrExcel community enjoy providing answers to your Excel questions, but we need to know that we're actually helping you. To aid in this, we decided to use the new 'Mark as solution' functionality. This allows the Original Poster (OP) of a thread to mark the solution post...

www.mrexcel.com