
Next: auto hide 
Author 
Message 
vmohan1978 External
Since: Jan 29, 2009 Posts: 7

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

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

Posted: 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 .
"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

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

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

Posted: 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 .
"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

Posted: 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 .
> "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 



