prlondhe
08-24-2016, 07:54 AM
Hi
I have 2 sheets with the following columns
sheet1(master)
column headers
code ser_no name
code number contains text & numbers
serial no is numeric
sheet2(xyz)
column header
serial no is numeric
code ser_no name
code number contains text & numbers
columns in sheet1 & sheet2 are formatted as number
the normal formula =index(master!c:c,match(sheet(2) col1&sheet(2)col2,master!a:a&master!b:b,false)) gives me correct results.
now i want a code in vba with userform to replace the name in sheet(2) with 2 textbox
i use the following formula but gives me error
activecell.value=application.index(sheets("master").range("c2:c1002"),application.match(textbox1&textbox2,sheets("master").range("a2:a1002")&sheets("master").range("b2:b1002"),false))
can anybody help
I have 2 sheets with the following columns
sheet1(master)
column headers
code ser_no name
code number contains text & numbers
serial no is numeric
sheet2(xyz)
column header
serial no is numeric
code ser_no name
code number contains text & numbers
columns in sheet1 & sheet2 are formatted as number
the normal formula =index(master!c:c,match(sheet(2) col1&sheet(2)col2,master!a:a&master!b:b,false)) gives me correct results.
now i want a code in vba with userform to replace the name in sheet(2) with 2 textbox
i use the following formula but gives me error
activecell.value=application.index(sheets("master").range("c2:c1002"),application.match(textbox1&textbox2,sheets("master").range("a2:a1002")&sheets("master").range("b2:b1002"),false))
can anybody help