software

Below is what sheet 2 of my file looks like...the first column is a list
that column F in my file has a pull-done for. Then in column I-T of my
file, I have VLOOKUP formulas to pick up what you see here (I will
change O's once I get this to work, and there are 12 columns, you just
don't see them here). Column I works fine, Column J and from then on, I
get #ref!. The o's are a quot;Insert, Named, Definedquot; range named MYLOOKUP1.
SURV O O O O O O
LTR O O O O O O
BRC O O O O O O
INVITE O O O O O O
SM O O O O O O
#10 win O O O O O O
#9 env O O O O O O
HELP!!!--
roger_home
------------------------------------------------------------------------
roger_home's Profile: www.excelforum.com/member.php...oamp;userid=16434
View this thread: www.excelforum.com/showthread...hreadid=516558and how is your range defined?

--
Don Guillett
SalesAid Software

quot;roger_homequot; gt; wrote
in message ...
gt;
gt; Below is what sheet 2 of my file looks like...the first column is a list
gt; that column F in my file has a pull-done for. Then in column I-T of my
gt; file, I have VLOOKUP formulas to pick up what you see here (I will
gt; change O's once I get this to work, and there are 12 columns, you just
gt; don't see them here). Column I works fine, Column J and from then on, I
gt; get #ref!. The o's are a quot;Insert, Named, Definedquot; range named MYLOOKUP1.
gt;
gt;
gt;
gt; SURV O O O O O O
gt; LTR O O O O O O
gt; BRC O O O O O O
gt; INVITE O O O O O O
gt; SM O O O O O O
gt; #10 win O O O O O O
gt; #9 env O O O O O O
gt; HELP!!!
gt;
gt;
gt; --
gt; roger_home
gt; ------------------------------------------------------------------------
gt; roger_home's Profile:
gt; www.excelforum.com/member.php...oamp;userid=16434
gt; View this thread: www.excelforum.com/showthread...hreadid=516558
gt;
You have another response in your other thread.

roger_home wrote:
gt;
gt; Below is what sheet 2 of my file looks like...the first column is a list
gt; that column F in my file has a pull-done for. Then in column I-T of my
gt; file, I have VLOOKUP formulas to pick up what you see here (I will
gt; change O's once I get this to work, and there are 12 columns, you just
gt; don't see them here). Column I works fine, Column J and from then on, I
gt; get #ref!. The o's are a quot;Insert, Named, Definedquot; range named MYLOOKUP1.
gt;
gt; SURV O O O O O O
gt; LTR O O O O O O
gt; BRC O O O O O O
gt; INVITE O O O O O O
gt; SM O O O O O O
gt; #10 win O O O O O O
gt; #9 env O O O O O O
gt; HELP!!!
gt;
gt; --
gt; roger_home
gt; ------------------------------------------------------------------------
gt; roger_home's Profile: www.excelforum.com/member.php...oamp;userid=16434
gt; View this thread: www.excelforum.com/showthread...hreadid=516558

--

Dave Peterson