Named Formula Usage in VBA

[terryb3582]

I have a Named Formula in Excel 2007 called "CodeLookup" (ie CodeLookup refers to =ISNA(IF.........) that references a Product code value in a cell and then uses VLOOKUP on another worksheet in the same workbook to return a secondary product code. How can I do it all in one step? Can I do it in one step?

How do you reference a Named Formula in VBA that varies with each cell?

C4=702 (Which is the Primary Product code)
How can I look up "702" in the lookup table and then write that value to cell C4?

If I paste my formula "CodeLookup" in A4, it references C4 and returns the secondary product to cell A4. I then have to copy/Paste the value into C4.

Can it be done in one step or does it have to be a two step process?

I'm a total newbie on this Excel VBA stuff!!! ....but it's very interesting!!

Thanks in advance for any feedback,

Terry

 

[terryb3582]

I figured it out.
Thanks.