Try this if it works
1. Add two columns of Party name and bill No with
formula =CONCATENATE(B7,C7) in both the sheets.
Party Name Bill no use formula
XYZ LTD 25 =CONCATENATE(B7,C7)
2.then try the VLOOKUP
if there is error in this vlookup after joining
Hi Ankur,
Do As Below :
1. In Both the Sheets, Insert one column.
2. In The column inserted, enter a formula : =PartyName BillNo. (where
Partyname is the cell for PartyName and BillNo. Is the cell for Bill No.)
3. Based on above inserted column, do the vlookup and you've done.
Hi Ankur,
I am not sure whether i have understood your query correctly or not.What i
understand is, if party name and bill no are same, then the corresponding
amount is extracted in sheet 2.
Based on that, i believe following is the code that you are looking for:
ActiveCell.FormulaR1C1 =