Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 27th 04, 04:35 PM
Jim
 
Posts: n/a
Default 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   Report Post  
Old October 27th 04, 04:42 PM
Paul Corrado
 
Posts: n/a
Default

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   Report Post  
Old October 27th 04, 04:44 PM
Arvi Laanemets
 
Posts: n/a
Default

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   Report Post  
Old October 27th 04, 04:58 PM
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







  #5   Report Post  
Old October 27th 04, 07:07 PM
Jim
 
Posts: n/a
Default

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











  #6   Report Post  
Old October 27th 04, 11:29 PM
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











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

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
irritating for people who suggest answers--but it's bad for you, too.

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
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










--

Dave Peterson

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

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
your business!

Got it!

Cheerrs

Jim'




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup finds a blank, but returns a zero - HELP! flummoxed Excel Discussion (Misc queries) 6 January 18th 05 03:15 PM
Vlookup Syntax Error YV New Users to Excel 9 December 23rd 04 05:28 PM
Vlookup Question Jeff Excel Discussion (Misc queries) 2 December 2nd 04 02:40 PM
Need help with modifying VLookUp Tom Excel Discussion (Misc queries) 4 December 2nd 04 12:44 AM
Vlookup with VBA Jeff Excel Discussion (Misc queries) 8 December 1st 04 02:41 PM


All times are GMT +1. The time now is 10:49 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017