Named Formula Usage in VBA

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
 

Forum statistics

Threads
1,081,517
Messages
5,359,234
Members
400,523
Latest member
ExcelNewbie98

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top