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 tw
Hey,
Please send me the file, i'll put the formula and send it to you.
Regards,
Rajesh Kunder
On Sat, Jun 20, 2009 at 2:24 PM, ankur wrote:
>
> Dear Members
>
> i have one problem
> in one sheet there is data as
> party name bill no.
> amount
>
> there are 100
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 =
"=IF(VL
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.
Mer
