Re: $$Excel-Macros$$ Formula to Replace 2nd List with Master List

2013-01-27 Thread amar takale
ok,thanks for reply On Sat, Jan 26, 2013 at 6:02 AM, Bé Trần Văn wrote: > I ""; "" to ignore the error # N/A if column A MASTER of 2 LIST list > and the elements are not the same, you try. > > 2013/1/25, amar takale : >> Dear betnmtdongnai, >> what is use of ("";"";) in formula .as like Prince si

Re: $$Excel-Macros$$ Formula to Replace 2nd List with Master List

2013-01-25 Thread Bé Trần Văn
I ""; "" to ignore the error # N/A if column A MASTER of 2 LIST list and the elements are not the same, you try. 2013/1/25, amar takale : > Dear betnmtdongnai, > what is use of ("";"";) in formula .as like Prince simple vlookup aslo > got answer > > On Thu, Jan 24, 2013 at 9:21 PM, Bé Trần Văn >

Re: $$Excel-Macros$$ Formula to Replace 2nd List with Master List

2013-01-24 Thread amar takale
Dear betnmtdongnai, what is use of ("";"";) in formula .as like Prince simple vlookup aslo got answer On Thu, Jan 24, 2013 at 9:21 PM, Bé Trần Văn wrote: > At D3 of sheet List you can use the formula: > > =IF(A3="";"";VLOOKUP(A3;MASTER!$A$3:$B$9;2;0)) > > And Fill down, See Attachment > > 2013/1/

Re: $$Excel-Macros$$ Formula to Replace 2nd List with Master List

2013-01-24 Thread Bé Trần Văn
At D3 of sheet List you can use the formula: =IF(A3="";"";VLOOKUP(A3;MASTER!$A$3:$B$9;2;0)) And Fill down, See Attachment 2013/1/24, Hilary Lomotey : > Hello Experts, > > In the file attached, i have a master list with names and codes(master > sheet), and then another list (list sheet). The code

Re: $$Excel-Macros$$ Formula to Replace 2nd List with Master List *

2013-01-24 Thread Hilary Lomotey
NO WORRIES, I SOLVED IT, THANKS On Thu, Jan 24, 2013 at 12:00 PM, Hilary Lomotey wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (resp...@gmail.com) Add cleanup > rule

$$Excel-Macros$$ Formula to Replace 2nd List with Master List

2013-01-24 Thread Hilary Lomotey
Hello Experts, In the file attached, i have a master list with names and codes(master sheet), and then another list (list sheet). The codes in the master sheet does not match with that of the other list, so i used the normal index and match to retrieve the different values, the issue is that i wan