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

Hi Jim

the reason we ask people not to multi-post is that someone may spend
considerable time working out an answer for a question only to discover that
someone else has answered it in another group - which is, as you might
imagine, annoying for those of us who do answer questions in this group.

Regards
JulieD



"Jim" wrote in message
...
Miss if u r not aware, not everyone is like u n me , subscribe to both
newsgroups! So sometimes u get better answers and by the way its none of
your business!

Got it!

Cheerrs

Jim'


--




"JulieD" wrote in message
...
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