View Single Post
  #4   Report Post  
JulieD
 
Posts: n/a
Default

Hi

you've also received replies to your post at microsoft.public.excel - just
for future info, it's generally not necessary to post the same question to
multiple groups.

Cheers
JulieD

"Jim" wrote in message
...
Hi i just started off with VLOOKUP function but it doesn't seem to work ,
i
want ot have the basic understanding of how it functions?

Example

A B C
1 ITEMS COST
2 Ham 2
3 Cheese 4
4 Eggs 6
5 Pork 5


Now if i want to lookup how much does ham costs?

the forumal wd be:
=VLOOKUP(Ham,A1:B5,2,FALSE)

I believ the formula is right , but i am confused in which cell do i need
to
write it? If i write it in C2, it returns #NAME?.

Pls tell where do i need to write the formula?
--
Any help appreciated!
Jim
India