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
|