Thread:Sirebel/@comment-30967537-20170323002046/@comment-30967537-20170329142124

With regards to both of the previous posts (from Tkoostra and Sirebel) and my responses ...

As long as you are able to extract the same data structure that I have used, then the current spreadsheet data could be wiped and re-populated from your database ... then there will be no naming inconsistencies.

The make, model, year fields are informational only ... as long as the other rows are populated consistently (and, if they're being extracted from your database, there's no reason they shouldn't be) then the data should slot right in and the EXAMPLE row formula cells could be copied onto each row and it should work perfectly.

The speadsheet was written in Excel.

I tested it with OpenOffice's Calc. It doesn't support the IFERROR function. It took a l-o-n-g time to convert all the formulas from Excel's comma-delimited format to Calc's semi-colon-delimited format but worked fine after that.