Replace cells with multiple search critera

I've searched around, and I can't find an answer for this...

I have a pretty big spreadsheet of names of ships and other data, and I realized that some of the names are duplicate. I've made a separate table with all of the unique names, and added numbers to differentiate. So say I want to replace the name of any record in the second table that is ShipName="Jason", ShipType="sloop", Year>=1760 & <=1780 with ShipName="Jason (1)".

I'm assuming this can be done with a VBA Replace, but I'm new to VBA and haven't been able to figure out how to use multiple search criteria. Any help is appreciated!

ShipName	ShipType	FirstYear	LastYear
Jason (1)	sloop	1760	1780
Jason (2)	frigate	1770	1800

ShipName	ShipType	Year
Jason	sloop	1760
Jason	sloop	1761
Jason	sloop	1762
Jason	sloop	1773
Jason	frigate	1770
Jason	frigate	1775
Jason	frigate	1780

Is all your data in the same columns?

It looks like this. I gave the columns unique names to make it clearer

ShipNameNew	ShipTypeNew	FirstYear	LastYear		ShipNameOriginal	ShipTypeOriginal	YearOriginal
Jason (1)	sloop	1760	1780		Jason	sloop	1760
Jason (2)	sloop	1770	1800		Jason	sloop	1761
					Jason	sloop	1762
					Jason	sloop	1773
					Jason	frigate	1770
					Jason	frigate	1775
					Jason	frigate	1780