Help!

Whether VLOOKUP can find Text

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Worksheet Functions RSS
Next:  auto hide  
Author Message
vmohan1978
External


Since: Jan 29, 2009
Posts: 7



PostPosted: Fri Jan 30, 2009 4:26 am    Post subject: Whether VLOOKUP can find Text
Archived from groups: microsoft>public>excel>worksheet>functions (more info?)

Whether Vlookup will find Text?
In sheet 1 my data is as follows
B C D
1 Foreman Day 375
2 Mason Day 250
3 Fitter Day 250
In Sheet 2

My formula is as foolows
B C
5 Foreman VLOOKUP(B5,Sheet1!$B$1:$D$50,2) i NEED A RESULT OF dAY
Back to top
muddan madhu
External


Since: Jan 26, 2009
Posts: 18



PostPosted: Fri Jan 30, 2009 4:41 am    Post subject: Re: Whether VLOOKUP can find Text [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

yes of course,

VLOOKUP(B5,Sheet1!$B$1:$D$50,2,false)


On Jan 30, 12:26 pm, vmohan1978
wrote:
> Whether Vlookup will find Text?
> In sheet 1 my data is as follows
>         B       C       D
> 1       Foreman Day     375
> 2       Mason   Day     250
> 3       Fitter  Day     250
>   In Sheet 2
>
> My formula is as foolows
>             B                  C
>  5     Foreman  VLOOKUP(B5,Sheet1!$B$1:$D$50,2)  i NEED A RESULT OF dAY
Back to top
vmohan1978
External


Since: Jan 29, 2009
Posts: 7



PostPosted: Fri Jan 30, 2009 4:53 am    Post subject: Re: Whether VLOOKUP can find Text [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thank you very much it worked perfectly Smile.

"muddan madhu" wrote:

> yes of course,
>
> VLOOKUP(B5,Sheet1!$B$1:$D$50,2,false)
>
>
> On Jan 30, 12:26 pm, vmohan1978
> wrote:
> > Whether Vlookup will find Text?
> > In sheet 1 my data is as follows
> > B C D
> > 1 Foreman Day 375
> > 2 Mason Day 250
> > 3 Fitter Day 250
> > In Sheet 2
> >
> > My formula is as foolows
> > B C
> > 5 Foreman VLOOKUP(B5,Sheet1!$B$1:$D$50,2) i NEED A RESULT OF dAY
>
>
Back to top
T. Valko
External


Since: Nov 24, 2006
Posts: 3649



PostPosted: Fri Jan 30, 2009 7:46 am    Post subject: Re: Whether VLOOKUP can find Text [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Try it like this:

=VLOOKUP(B5,Sheet1!$B$1:$D$50,2,0)

The 0 means exact match. When you leave out that last argument the formula
assumes your data is sorted in ascending order and if an exact match doesn't
exist you want an "approximate" match. However, if the data isn't sorted
then you can get incorrect results.

--
Biff
Microsoft Excel MVP


"vmohan1978" wrote in message

> Whether Vlookup will find Text?
> In sheet 1 my data is as follows
> B C D
> 1 Foreman Day 375
> 2 Mason Day 250
> 3 Fitter Day 250
> In Sheet 2
>
> My formula is as foolows
> B C
> 5 Foreman VLOOKUP(B5,Sheet1!$B$1:$D$50,2) i NEED A RESULT OF dAY
>
Back to top
Ashish Mathur
External


Since: May 21, 2005
Posts: 276



PostPosted: Fri Jan 30, 2009 9:10 am    Post subject: Re: Whether VLOOKUP can find Text [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi,

Just add 0 as the last argument. Please try this

VLOOKUP(B5,Sheet1!$B$1:$D$50,2,0)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"vmohan1978" wrote in message

> Whether Vlookup will find Text?
> In sheet 1 my data is as follows
> B C D
> 1 Foreman Day 375
> 2 Mason Day 250
> 3 Fitter Day 250
> In Sheet 2
>
> My formula is as foolows
> B C
> 5 Foreman VLOOKUP(B5,Sheet1!$B$1:$D$50,2) i NEED A RESULT OF dAY
>
Back to top
vmohan1978
External


Since: Jan 29, 2009
Posts: 7



PostPosted: Fri Jan 30, 2009 9:10 am    Post subject: Re: Whether VLOOKUP can find Text [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thank you very much it worked perfectly Smile.
"Ashish Mathur" wrote:

> Hi,
>
> Just add 0 as the last argument. Please try this
>
> VLOOKUP(B5,Sheet1!$B$1:$D$50,2,0)
>
> --
> Regards,
>
> Ashish Mathur
> Microsoft Excel MVP
> www.ashishmathur.com
>
> "vmohan1978" wrote in message
>
> > Whether Vlookup will find Text?
> > In sheet 1 my data is as follows
> > B C D
> > 1 Foreman Day 375
> > 2 Mason Day 250
> > 3 Fitter Day 250
> > In Sheet 2
> >
> > My formula is as foolows
> > B C
> > 5 Foreman VLOOKUP(B5,Sheet1!$B$1:$D$50,2) i NEED A RESULT OF dAY
> >
Back to top
Ashish Mathur
External


Since: May 21, 2005
Posts: 276



PostPosted: Fri Jan 30, 2009 12:10 pm    Post subject: Re: Whether VLOOKUP can find Text [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

You are welcome.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"vmohan1978" wrote in message

>
> Thank you very much it worked perfectly Smile.
> "Ashish Mathur" wrote:
>
>> Hi,
>>
>> Just add 0 as the last argument. Please try this
>>
>> VLOOKUP(B5,Sheet1!$B$1:$D$50,2,0)
>>
>> --
>> Regards,
>>
>> Ashish Mathur
>> Microsoft Excel MVP
>> www.ashishmathur.com
>>
>> "vmohan1978" wrote in message
>>
>> > Whether Vlookup will find Text?
>> > In sheet 1 my data is as follows
>> > B C D
>> > 1 Foreman Day 375
>> > 2 Mason Day 250
>> > 3 Fitter Day 250
>> > In Sheet 2
>> >
>> > My formula is as foolows
>> > B C
>> > 5 Foreman VLOOKUP(B5,Sheet1!$B$1:$D$50,2) i NEED A RESULT OF dAY
>> >
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Worksheet Functions All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum