Vlookup help
Posted by Mike on January 04, 2002 2:56 PM
I have a cell called 'dblu' that contains a built up value of 'ff6db3'. I'm then using the function: vlookup(dhsz,dblu,3,false) where the array I want to refer to is 'ff6db3' (the value of the cell range). Returns a value of "N/A". I assume it's trying to look in an array called 'dblu'.
Anyone tried to do something like this and any suggestions?
Posted by Scott on January 04, 2002 3:02 PM
I'm a little confused. You say you have a "cell" called dblu. Is this not an array? according to your forumula, you are trying to lookup a cell "dhsz" in the table array "dblu" and return the third column in the table array. If "dblu" does not have at least 3 columns, you would get the "N/A" symbol as a result.
If I don't have this correct, please repost.
Posted by Aladin Akyurek on January 04, 2002 3:10 PM
Is it perhaps
=VLOOKUP(dhsz,INDIRECT(dblu),3,0)
where I think "dhsz" to be a cell name and "dblu" again the name of a cell which houses a range that has at least 3 columns.
Otherwise, please provide more detail.
Aladin
Posted by Mike on January 04, 2002 3:13 PM
I have many combinations of array's and I'm building the array name, in this case, 'ff6db3' in a cell called 'dblu'. I'm trying to use the cell value as the array name.
Posted by mike on January 04, 2002 3:15 PM
You're the man - it worked fine!! Thanks.
