VLOOKUP keeps saying #NAME?

[Guest]

=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?

 

[Anne Troy]

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

 

[Niek Otten]

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.