Whether VLOOKUP can find Text

  • Thread starter Thread starter vmohan1978
  • Start date Start date
V

vmohan1978

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
 
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.
 
Back
Top