Remember Me?

#1
October 27th 04, 04:35 PM
 Jim Posts: n/a
VLOOKUP Pls help!!!!

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

#2
October 27th 04, 04:42 PM

When you enter a text criteria directly, it needs to be in ""'s

=VLOOKUP("Ham",A1:B5,2,FALSE)

"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

#3
October 27th 04, 04:44 PM
 Arvi Laanemets Posts: n/a

Hi

=VLOOKUP("Ham",\$A\$2:\$B\$5,2,FALSE)
or
=VLOOKUP(A2,\$A\$2:\$B\$5,2,FALSE)

Arvi Laanemets

"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

#4
October 27th 04, 04:58 PM
 JulieD Posts: n/a

Hi

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

#5
October 27th 04, 07:07 PM
 Jim Posts: n/a

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

Got it!

Cheerrs

Jim'

--

"JulieD" wrote in message
...
Hi

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

#6
October 27th 04, 11:29 PM
 JulieD Posts: n/a

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

Got it!

Cheerrs

Jim'

--

"JulieD" wrote in message
...
Hi

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

#7
October 28th 04, 01:46 AM
 Dave Peterson Posts: n/a

Just to add to JulieD's response.

If you do feel the need to post to lots of newsgroups (I agree with JulieD and
don't think you need to), include all your newsgroups in one post.

This is called crossposting and when someone responds to your message, it'll be
seen in the other groups.

What you did is called multiposting. And each thread is independent. This is

You have to check multiple newsgroups for responses. And you don't get the
added benefit of someone seeing all the ideas and improving on them. They're
limited to just the thread they see.

JulieD wrote:

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

Got it!

Cheerrs

Jim'

--

"JulieD" wrote in message
...
Hi

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

--

Dave Peterson

#8
October 28th 04, 01:50 AM
 Gord Dibben Posts: n/a

Jim

There are a great bunch of regulars that monitor all the Excel News Groups.

Posting to one group only will ensure that your post is read by 100% of the
regulars and MVP's.

Julie is one of those regulars.

Pointing out that multi-posting is unnecessary and wasteful of band-width and
user resources should be everyone's business.

I would like to direct you to Chip Pearson's "Hints for new posters" site.

http://www.cpearson.com/excel/newposte.htm

Gord Dibben Excel MVP

On Wed, 27 Oct 2004 14:07:07 -0400, "Jim" wrote:

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

Got it!

Cheerrs

Jim'

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post flummoxed Excel Discussion (Misc queries) 6 January 18th 05 03:15 PM YV New Users to Excel 9 December 23rd 04 05:28 PM Jeff Excel Discussion (Misc queries) 2 December 2nd 04 02:40 PM Tom Excel Discussion (Misc queries) 4 December 2nd 04 12:44 AM Jeff Excel Discussion (Misc queries) 8 December 1st 04 02:41 PM

All times are GMT +1. The time now is 12:52 PM.