Whether VLOOKUP can find Text
 

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

Whether VLOOKUP can find Text
 

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

Whether VLOOKUP can find Text
 

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

Whether VLOOKUP can find Text
 

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

Whether VLOOKUP can find Text
 

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

Whether VLOOKUP can find Text
 

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

Whether VLOOKUP can find Text
 

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