| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup on changing range
Well, I think you can just use the entire range, right.
=VLOOKUP(A1,$A:$B,2,FALSE) Maybe you are talking about a dynamic range... Check these out: http://www.ozgrid.com/Excel/DynamicRanges.htm http://www.contextures.com/xlNames01.html http://www.contextures.com/xlNames02.html Regards, Ryan-- -- RyGuy "Yossi evenzur" wrote: Hi I need to the syntax for running a Vlookup on a fixed array, but each time the size of the array is changing. is there any command for this or can i use a variable that will stand for range each time? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing the range for averages with out changing the formula. | Excel Worksheet Functions | |||
| How do I copy a vlookup formula without changing the data range? | Excel Worksheet Functions | |||
| VLOOKUP, changing ranges | Excel Discussion (Misc queries) | |||
| changing data in range of vlookup | Excel Discussion (Misc queries) | |||
| Changing the vlookup cell | Excel Programming | |||
Threaded Mode
