Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Approach for lookups
Hi
I have a working model now which uses named ranges, and I have written a VBA function which looks up a value in the first column which is my index and returns a required column intersection cell. However, this did require a little jiggery pokery for the want of a better word to do this. Have I missed some fundamental function which would do this in VBA from a named range. Basically I use the range.Find method,and have to find the offset from the start of the range in order to get my row and for this I have to use R1C1 relative format and then add 1. This works but it seems a little much to have to do to acheive this from VBA, any help would be appreciated. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is the right approach? | Excel Worksheet Functions | |||
How to approach this? | Excel Discussion (Misc queries) | |||
New approach | Excel Programming | |||
LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. | Excel Worksheet Functions | |||
How do I approach this? | Excel Programming |