Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need to know give matrixes a name...
Hi fellas!
I've just signed in into the forum... Excuse my english, please! As logical i'm looking for some excel answers. Trying to make a good stock control file i found some others, but there's one that got my attention. That file shows this: "If(B210;VLOOKUP(B21;listadomateriales;2;0);" ◄ INPUT CODE")" In the second variable of the VLOOKUP appears "listadomateriales" that by some reason is a matrix written in a different sheet. This guy made that a part (matrix) of some sheet could be call by a specific name just like "listadomateriales". 1st. I want to know how this is called. 2nd. I want to know how he did this. 3rd. What limits does this have? Could be this matrix the same size of the sheet? Could I set the matrix rows and colls number? Elvagonumero1 from Venezuela |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to know give matrixes a name...
elvagonumero1 used his keyboard to write :
Hi fellas! I've just signed in into the forum... Excuse my english, please! As logical i'm looking for some excel answers. Trying to make a good stock control file i found some others, but there's one that got my attention. That file shows this: "If(B210;VLOOKUP(B21;listadomateriales;2;0);" ◄ INPUT CODE")" In the second variable of the VLOOKUP appears "listadomateriales" that by some reason is a matrix written in a different sheet. This guy made that a part (matrix) of some sheet could be call by a specific name just like "listadomateriales". 1st. I want to know how this is called. 2nd. I want to know how he did this. 3rd. What limits does this have? Could be this matrix the same size of the sheet? Could I set the matrix rows and colls number? Elvagonumero1 from Venezuela This is the name assigned to the range containing the table (or matrix) where the data is stored. To get you started, you need to look up 'Defined Names' in Excel help and learn the what and how of working with names. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup I give up | Excel Discussion (Misc queries) | |||
I give up | Excel Discussion (Misc queries) | |||
problem with creating a serie of matrixes | Excel Programming | |||
Don't Give Up! | Excel Programming | |||
Give RELEVANT responses to questions. DO NOT give usless list | Excel Worksheet Functions |