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