hi, hopefull someone can help here I have a excel sheet which tracks payment accounts
for example

Name A/C Number Amount per month Mar April May June July
P Roberts C001254 28.56 25.56 0 28.56 28.56 28.56
C Jones A00001 17.22 17.22 17.22 17.22 17.22 17.22

Currently we are manually inputing payments recieved each month from a .csv file recieved from our bank which contains the following info.

24-03-04


date description type amount
10/3 Benjamin D Skull C00001 CDT 28.45
10/3 Emma K Bick A00003 CDT 17.99
10/3 C Jones A00001 CDT 12.45
26/3 P Roberts C001254 CDT 8.21

this file is always called download.csv
I am trying to automaticly transfer data from download.csv to the main sheet and put the data in the right places is Vlookup the way to go?
Thanks in advance.

if your spreadsheet starts off with just 2 columns (name, account number) and headers for each month then you can use vlookup.... you would lookup the account number in the csv file (something like this =vlookup(B2,[download.csv.xls]Sheet1!$1:$65536,2,false) or to make it work even better you would remove the errors by doing -if(iserror(vlookup(B2,[download.csv.xls]Sheet1!$1:$65536,2,false)),"0.00",vlookup(B2,[download.csv.xls]Sheet1!$1:$65536,2,false))) [this would remove the #N/A's that you might get and replace them with 0.00.

The only issue with using vlookup is that once you have done it you would want to copy and paste special the values back into those cells so that when you got the next month's download it wouldn't alter the figures.