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? |
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? |
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? |
All times are GMT +1. The time now is 01:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com