to set rownumber

P

pol

ActiveCell.Formula = "=IF(COUNTIF([item.xls]item!B:B,
G7),VLOOKUP(G7,[item]item!B:L,11,0))

In the above formula the the G7 value shoulbe changed with G and active row
number

example

if current active row =3 then G7 should be changed into G3
if current active row =8 then G7 should be changed into G8

Please help ro rewrite the formula

Pol
 
S

Stefi

Try this:

ActiveCell.FormulaR1C1 = "=IF(COUNTIF([item.xls]item!C2,
RC7),VLOOKUP(RC7,[item.xls]item!C2:C12,11,0))"

Regards,
Stefi

„pol†ezt írta:
 
P

pol

Thanks too much, it is working fine

Stefi said:
Try this:

ActiveCell.FormulaR1C1 = "=IF(COUNTIF([item.xls]item!C2,
RC7),VLOOKUP(RC7,[item.xls]item!C2:C12,11,0))"

Regards,
Stefi

„pol†ezt írta:
ActiveCell.Formula = "=IF(COUNTIF([item.xls]item!B:B,
G7),VLOOKUP(G7,[item]item!B:L,11,0))

In the above formula the the G7 value shoulbe changed with G and active row
number

example

if current active row =3 then G7 should be changed into G3
if current active row =8 then G7 should be changed into G8

Please help ro rewrite the formula

Pol
Click to expand...
Click to expand...
 
S

Stefi

You are welcome! Thanks for the feedback!
Stefi

„pol†ezt írta:
Thanks too much, it is working fine

Stefi said:
Try this:

ActiveCell.FormulaR1C1 = "=IF(COUNTIF([item.xls]item!C2,
RC7),VLOOKUP(RC7,[item.xls]item!C2:C12,11,0))"

Regards,
Stefi

„pol†ezt írta:
ActiveCell.Formula = "=IF(COUNTIF([item.xls]item!B:B,
G7),VLOOKUP(G7,[item]item!B:L,11,0))

In the above formula the the G7 value shoulbe changed with G and active row
number

example

if current active row =3 then G7 should be changed into G3
if current active row =8 then G7 should be changed into G8

Please help ro rewrite the formula

Pol
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

To check two sheets in a single file in Vlookup() 1
to create a formula by removing RC[number] 2
Need a help display 0 value 2
To run the formula from any active cell 6
Countif and Vlookup in a single formula 2
to workout the formula from many column.. 1
Code to Allocate Funds 2
To give paste special (value) in macros 1

Top