formula with code

[asyamonique]

Sheets("info").Range("B6").Value =????

How can we add up a vlookup formula into that code?
Thanks

 

[texasalynn]

enter your vlookup formula, then do a macro record
select the cell with the formula, press F2 and enter. stop the recorder
the macro will then have the formula, which you will need to modify. Post back with that code and questions

 

[asyamonique]

enter your vlookup formula, then do a macro record
select the cell with the formula, press F2 and enter. stop the recorder
the macro will then have the formula, which you will need to modify. Post back with that code and questions

Sheets("Result").Range("B6:B25").Value = "=VLOOKUP(Result!RC[-1],'0600'!C[-1]:C[24],3)"

Hi,
Thats the one i've got but still its not giving me real result.
Thanks