Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup in a second worksheet
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup in a second worksheet
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 "SHIPP" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting data from one Worsheet to Another Worksheet with common link value | Excel Discussion (Misc queries) | |||
Vlookup worksheet function | Excel Worksheet Functions | |||
Updating formula with link to another worksheet using vlookup | Links and Linking in Excel | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
Refrencing another cell in a worksheet that "could" exist | Excel Worksheet Functions |