Hello,

First i want to thank everyone for all the help. I have been using this website for a long time and it solved a lot of my problems.

I have been trying to find out a way to copy some data and i couldn't succeed so i am opening this thread.

Problem is:

There is a stock excel that we keep our records and we are trying to update it everyday, after deliveries. Delivery numbers come from a coworker in excel format.

I used VLOOKUP formula and it solved my first problem which is copying only the delivered parts and amounts to our stock excel. But there are 2 problems:

- In false situation, the formula write NA to the cell and that breaks abstracting formulas. If i got 10 parts and there is no delivery that day i still have 10 but NA break this since 10 - NA = NA

- Other problem is I want to keep only the exact values because i will delete de second delivery excel after my work is done. so after getting the number with vlookup, i must delete the formula and only the exact number should stay.

So my working look up formula is like: =VLOOKUP(A2; [delivery.xlsx]Temp1!$A$2:$C$15; 2; FALSE)

My main stock and dispatch excels are like the photos i attached.

My goal is;

- Copying the numbers from dispatch excel without opening it with =VLOOKUP(A2; 'C:\Users\Lenovo\Desktop/[delivery.xlsx]Temp1'!$A$2:$B$15; 2; FALSE) formula on my main excel.

- giving 0 value to NA cells

- Making the numbers exact so they won't change.

I can copy the formula to my main excel colums manually, if you can help me with the things mentioned above i would be greatful.

First i want to thank everyone for all the help. I have been using this website for a long time and it solved a lot of my problems.

I have been trying to find out a way to copy some data and i couldn't succeed so i am opening this thread.

Problem is:

There is a stock excel that we keep our records and we are trying to update it everyday, after deliveries. Delivery numbers come from a coworker in excel format.

I used VLOOKUP formula and it solved my first problem which is copying only the delivered parts and amounts to our stock excel. But there are 2 problems:

- In false situation, the formula write NA to the cell and that breaks abstracting formulas. If i got 10 parts and there is no delivery that day i still have 10 but NA break this since 10 - NA = NA

- Other problem is I want to keep only the exact values because i will delete de second delivery excel after my work is done. so after getting the number with vlookup, i must delete the formula and only the exact number should stay.

So my working look up formula is like: =VLOOKUP(A2; [delivery.xlsx]Temp1!$A$2:$C$15; 2; FALSE)

My main stock and dispatch excels are like the photos i attached.

My goal is;

- Copying the numbers from dispatch excel without opening it with =VLOOKUP(A2; 'C:\Users\Lenovo\Desktop/[delivery.xlsx]Temp1'!$A$2:$B$15; 2; FALSE) formula on my main excel.

- giving 0 value to NA cells

- Making the numbers exact so they won't change.

I can copy the formula to my main excel colums manually, if you can help me with the things mentioned above i would be greatful.