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?