Excel 2007 : Vlookup?

**jhamil** · 03-05-2009, 06:21 PM

When i try to use vlookup in a different spreadsheet from the range in the formula it returns 0 (zero).

**JBeaucaire** · 03-05-2009, 06:37 PM

Show us the formula.

**jhamil** · 03-06-2009, 11:35 AM

=vlookup(212,lirica,6)

212= is the referenced value in the first collum
"lirica"= is the name of the range in the spread sheet
6= number of the collum where i'm doing the search
i'm trying to pull the information to a different sheet (same workbook) but it comes back "0"; also when i write the formula in the the sheet where the range is, it works properly.
Thank you for your reply.

**NBVC** · 03-06-2009, 11:36 AM

What happens with:

=vlookup(212,lirica,6,0)

**jhamil** · 03-06-2009, 12:55 PM

when i use it in a different sheet(same workbook) it reads 0. but when i use it in the same sheet where the range is (lirica) it works

**NBVC** · 03-06-2009, 01:01 PM

when you are in the sheet you want to put the formula in and go to Insert|Name|Define.

Pick lirica... and does the refers to field show the correct range including the sheet that it is on? =Sheet1!$F$1:$F$15

Maybe you can post the sample workbook if that doesn't fix it.

**jhamil** · 03-06-2009, 01:05 PM

thanks i'll check it out
How do i erase other ranges within a table?

**NBVC** · 03-06-2009, 01:21 PM

not sure exactly what you mean..

but if you want to delete a named range altogether... then go to Insert|Name|Define, select the named range and click Delete...

This may cause formulas in your workbook to go crazy if the named range you deleted was referred to.

Is that what you meant?

**jhamil** · 03-06-2009, 03:39 PM

yeah thank you it works

**NBVC** · 03-06-2009, 03:49 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save