Index and Vlookup question (Multiple Condition)

Hi,

When you say you have another 'spreadsheet' do you really mean that you have another Excel workbook, or is there in fact only one workbook with the data you show in one sheet and the A, B & C columns without column D in a second worksheet?

Assuming the former and the key field is the contract number, then in column D of the second workbook enter the following formula in D1 and copy down

Formula:

=VLOOKUP(C1,'C:\[Book1.xls]Sheet1'!C:D,2,False)

Change the Book1 and Sheet1 references as appropriate.