Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VLOOKUP keeps saying #NAME?
=VLOOKUP(A1; 'vegetable soup vlookup example 1'!D1:E100; 2, 1) is my formula
- I'm trying to play around w/ it before I do my spreadsheet, and I need help! It keeps saying #NAME? - What's up? |
#2
|
|||
|
|||
VLOOKUP keeps saying #NAME?
What is 'vegetable soup vlookup example 1'? Is that supposed to be another
file? Here's the syntax: =VLOOKUP(A1,[test.xls]Sheet1!$A$1:$B$4,2,FALSE) So, perhaps you need: =VLOOKUP(A1; [vegetable soup vlookup example 1]Sheetname!$D$1:$E$100, 2, 1) ************ Anne Troy www.OfficeArticles.com "GemznJewlz" wrote in message ... =VLOOKUP(A1; 'vegetable soup vlookup example 1'!D1:E100; 2, 1) is my formula - I'm trying to play around w/ it before I do my spreadsheet, and I need help! It keeps saying #NAME? - What's up? |
#3
|
|||
|
|||
VLOOKUP keeps saying #NAME?
Use the function wizard, and instead of typing the sheet and range name,
select them in the wizard. Also you have semicolons and commas mixed. -- Kind regards, Niek Otten "GemznJewlz" wrote in message ... =VLOOKUP(A1; 'vegetable soup vlookup example 1'!D1:E100; 2, 1) is my formula - I'm trying to play around w/ it before I do my spreadsheet, and I need help! It keeps saying #NAME? - What's up? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |