VLookup 2 Colums 2 spreadsheets

Hey,

Just a suggestion as I have not tried this out but could you not create a unique ID field in each of the spreadsheets which is made up of the account number and the other code (i.e. use CONCATENATE formula to create a field that links them together in one field).

Then you can use the VLOOKUP formula as normal based on this unique ID and return the turnover value you are looking for.

Thanks

Cheers danny That Worked spot on

j