Extracting Descriptions from one spreadsheet to appropriate part numbers on the other

[leadfeet]

I have attached two spreadsheets. The first spreadsheet has long descriptions and vehicle applications with the part numbers to the left. The 2nd spreadsheet is where I want the long descriptions to go under the "description" column. I want to accomplish this without altering any of the other information. Spreadsheet one has a little over 2500 parts, while spreadsheet two has over 3300, so there will be some descriptions in spreadsheet 2 that stay the same as before. I want the long descriptions in sheet 1 to replace the data in sheet 2's description column/cell for the matching part numbers entirely.

[FDibbins]

try this formula. but 1st note that the "Numbers" in "vehicle description" are actually text. to change them to numbers, highlight the entire range, scroll back up to the top and click on the little yellow square, select "convert to numbers"

=VLOOKUP(A2,'[Vehicles,Description All In One!(1).xlsx]Sheet1'!$B$3:$C$2572,2,FALSE)

if you dont want to do the above conversions, change the formula to this...

=IFERROR(VLOOKUP(TEXT(A2,"######"),'[Vehicles,%20Description%20All%20In%20One!(1).xlsx]Sheet1'!$B$3:$C$2572,2,FALSE),"")

[leadfeet]

FDibbins, thanks for responding. I am very much an amatuer when it comes to formulas. Where would I enter the formula and which spreadsheet? Sorry for my lack of expertise, I appreciate the help a great deal!