terryb3582
New Member
- Joined
- Sep 2, 2011
- Messages
- 4
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
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