Hi All,

I have 2 cell ranges named "maindata" and "otherdata", which are used
in a vlookup. Depending on the status of of the lookup value, the
Table Array would have to be either "maindata" or "otherdata". I have
therefore entered maindata and otherdata into the cells f1 and f2
respectively. This would avoid having to retype the Table Array,
instead pointing the Table Array to either cell f1 or f2. When I try
this, a N/A is returned can somebody please advise whether this is
possible to do?

regards

G.


--
chathag
------------------------------------------------------------------------
chathag's Profile: http://www.excelforum.com/member.php...o&userid=16519
View this thread: http://www.excelforum.com/showthread...hreadid=318767