Whether VLOOKUP can find Text

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
 
T

T. Valko

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need VLOOKUP to Work Two Ways 0
Vlookup & relative cell reference? 2
Lookup duplicate items in a list 5
VLOOKUP formula 3
VLOOKUP Function to return values in multipal Columns 6
Vlookup-Doesn't return values under 1 1
Adding up total hours worked on employee schedule using various criteria 0
Bugs in vlookup? 0

Top