| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Understanding R1C1
Thank you all; much clearer now.
"Alan" wrote: E6 would be: Cells(6,5) or you can just reference it as Range("E6") Your formula can't possibly work. References you are using, like "Column(R6C[5]) & column(R6C3)", are invalid references and will error. Column(R6C[5]) - column(R6C3)+1) This is the reference that you are using to denote which column value to return for the lookup. This is invalid. You need to look at Vlookup instructions again and restructure your formula to your needs or post better instructions about what you are trying to lookup, where you are looking, and what column to return if found. Alan "Alex" wrote: I'm trying to figure out what this code does. Can someone tell me what Column(R6C[5]) indicates? Is that cell E6? Thanks. The formula seems to be working, but it formula is extracting data from column N. Does Column(R6[5]) indicate column N? Thanks for your help. If Selection.Locked = False Then ActiveCell.FormulaR1C1 = "=if(ISERROR(VLOOKUP(RC3,IPDD!IPDD,(Column(R6C[5]) - column(R6C3)+1),FALSE)),"" "",VLOOKUP(RC3,IPDD!IPDD,(Column(R6C[5]) - column(R6C3)+1),FALSE))" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help on Converting R1C1 to A1 and A1 to R1C1..tia sa2 | Excel Discussion (Misc queries) | |||
| help on Converting R1C1 to A1 and A1 to R1C1..tia sa2 | Excel Worksheet Functions | |||
| help on Converting R1C1 to A1 and A1 to R1C1..tia sa2 | Excel Programming | |||
| Not understanding with/end with | Excel Programming | |||
| Not understanding If Not..Then nothing | Excel Programming | |||
Hybrid Mode
