PDA

View Full Version : vba code for index & match



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