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?