software

I have two worksheets. The first worksheet is called COSTS and contains the
data from which I want to look up values. The second worksheet is called
DETAIL. In the second worksheet I want to obtain a value from a cell in the
DETAIL worksheet, lookup that value in the COSTS worksheet and return the 2nd
column. I am using a named range (PRINTCOSTS) in the worksheet called COSTS.
My current formula, which doesn't work is as follows:

=VLOOKUP(B3,COSTS!PrintCosts,2,TRUE)

I get the following error #NAME?. Any help would be appreciated.
--
M. Shipp

try it without the costs!. Actually, excel should have changed that to the
workbook name if you tried it that way. If that doesn't work there is
something wrong with your defined name. try f5 goto and type in PrintCosts
to see what happens.

--
Don Guillett
SalesAid Software

quot;SHIPPquot; gt; wrote in message
...
gt;I have two worksheets. The first worksheet is called COSTS and contains the
gt; data from which I want to look up values. The second worksheet is called
gt; DETAIL. In the second worksheet I want to obtain a value from a cell in
gt; the
gt; DETAIL worksheet, lookup that value in the COSTS worksheet and return the
gt; 2nd
gt; column. I am using a named range (PRINTCOSTS) in the worksheet called
gt; COSTS.
gt; My current formula, which doesn't work is as follows:
gt;
gt; =VLOOKUP(B3,COSTS!PrintCosts,2,TRUE)
gt;
gt; I get the following error #NAME?. Any help would be appreciated.
gt; --
gt; M. Shipp