MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.