Update data from one sheet to another.

[Nitesh Khot]

Hey...
refer attached file and update me how to do this.

i want exported data in my sales target file.....

with products details.

if in exported file customer not found then sales vs target file display 0 in products colw/rows

 

[Bhawani]

Please have a look on below function without VBA is it that you were looking for

=IFERROR(IF(INDEX('exported data'!$A11:$L65010,MATCH('Sale Targate vs Achieve'!$A12,'exported data'!$A:$A,0),MATCH('Sale Targate vs Achieve'!F$1,'exported data'!$A$1:$L$1,0))=0,"",INDEX('exported data'!$A11:$L65010,MATCH('Sale Targate vs Achieve'!$A12,'exported data'!$A:$A,0),MATCH('Sale Targate vs Achieve'!F$1,'exported data'!$A$1:$L$1,0))),"")

Use above function in range("N2:F14"), please let know if something else require.


Regards,
Bhawani

 

[Nitesh Khot]

Its Working ..................But one thing is that it show value 0 (if available).....I want the same product value in sales vs target file.

 

[Bhawani]

Change "" with "0"
select desired range and press ctrl+h thats for replace type "" in find with and type "0" in replace with.
Press OK

Or paste this as earlier did

=IFERROR(IF(INDEX('exported data'!$A13:$L65012,MATCH('Sale Targate vs Achieve'!$A14,'exported data'!$A:$A,0),MATCH('Sale Targate vs Achieve'!N$1,'exported data'!$A$1:$L$1,0))=0,"0",INDEX('exported data'!$A13:$L65012,MATCH('Sale Targate vs Achieve'!$A14,'exported data'!$A:$A,0),MATCH('Sale Targate vs Achieve'!N$1,'exported data'!$A$1:$L$1,0))),"0")

 

[Nitesh Khot]

no no....it display 0 ....but i want same value from exported data...as it is.

 

[Bhawani]

=IFERROR(IF(INDEX('exported data'!$A$1:$L$65003,MATCH('Sale Targate vs Achieve'!$A2,'exported data'!$A:$A,0),MATCH('Sale Targate vs Achieve'!F$1,'exported data'!$A$1:$L$1,0))=0,"",INDEX('exported data'!$A$1:$L$65003,MATCH('Sale Targate vs Achieve'!$A2,'exported data'!$A:$A,0),MATCH('Sale Targate vs Achieve'!F$1,'exported data'!$A$1:$L$1,0))),"")

Try this function in F2 and drag it to right & down direction