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