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 "Insert, Named, Defined" 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: http://www.excelforum.com/member.php...o&userid=16434
View this thread: http://www.excelforum.com/showthread...hreadid=516558

and how is your range defined?

--
Don Guillett
SalesAid Software

"roger_home" wrote
in message ...

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 "Insert, Named, Defined" 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:
http://www.excelforum.com/member.php...o&userid=16434
View this thread: http://www.excelforum.com/showthread...hreadid=516558

You have another response in your other thread.

roger_home wrote:

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 "Insert, Named, Defined" 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: http://www.excelforum.com/member.php...o&userid=16434
View this thread: http://www.excelforum.com/showthread...hreadid=516558

--

Dave Peterson