v-lookup function is not working

N

nish

Hi guys

I am trying to use vlookup function in my spreadsheet..but it simply
doesn't work. Whenever I am trying to select the range from the other
spreadsheet and select the column number, then close the
paranthesis...its just goes away. No formula..nothing. I want to know
whether there is any function or option which I should select so that
vlookup function works??

Actually, I am facing this problem for the first time. Or else vlookup
usually works fine. Any help would be greatly appreciated
 
J

JE McGimpsey

nish said:
Hi guys

I am trying to use vlookup function in my spreadsheet..but it simply
doesn't work. Whenever I am trying to select the range from the other
spreadsheet and select the column number, then close the
paranthesis...its just goes away. No formula..nothing. I want to know
whether there is any function or option which I should select so that
vlookup function works??

Actually, I am facing this problem for the first time. Or else vlookup
usually works fine. Any help would be greatly appreciated

A little more detail might help...

What version of XL?

Is "the other spreadsheet" a different worksheet in the same workbook.
or a sheet in a different workbook?

Can you enter the formula manually?

What should the formula look like? What are the exact steps you're using?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top