Vlookup

[roger_home]

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!!!

[Don Guillett]

and how is your range defined?

--
Don Guillett
SalesAid Software
[email protected]
"roger_home" <[email protected]> wrote
in message news:[email protected]...
>
> 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]

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