VLOOKUP and names with Commas
 

I am using the below formula in D195 to look up an employee's hours.
B195 is Doe, Jane
from the search array, Doe, Jane is in B139 and Doe, Jack is in B138. The
values keep pulling from Jack. Is there a way force it to pull from Jane?

=VLOOKUP(B195,$B$9:$G$190,2)

VLOOKUP and names with Commas
 

Use False as the fourth parameter...
=VLOOKUP(B195,$B$9:$G$190,2,FALSE)

This is from HELP -
When the fourth parameter is either TRUE or is omitted, an exact or
approximate match is returned. If an exact match is not found, the next
largest value that is less than lookup_value is returned. If range_lookup is
either TRUE or is omitted, the values in the first column of table_array must
be placed in ascending sort order; otherwise, VLOOKUP might not return the
correct value.


--
Pl click the YES button
(if you see it - don''''''''t worry if you don''t),
if this answer was helpful.



"Rpt_Me4NotBeingSmart" wrote:

I am using the below formula in D195 to look up an employee's hours.
B195 is Doe, Jane
from the search array, Doe, Jane is in B139 and Doe, Jack is in B138. The
values keep pulling from Jack. Is there a way force it to pull from Jane?

=VLOOKUP(B195,$B$9:$G$190,2)

VLOOKUP and names with Commas
 

Thanks. That was very helpful. Oh, and I clicked yes.

"Sheeloo" wrote:

Use False as the fourth parameter...
=VLOOKUP(B195,$B$9:$G$190,2,FALSE)

This is from HELP -
When the fourth parameter is either TRUE or is omitted, an exact or
approximate match is returned. If an exact match is not found, the next
largest value that is less than lookup_value is returned. If range_lookup is
either TRUE or is omitted, the values in the first column of table_array must
be placed in ascending sort order; otherwise, VLOOKUP might not return the
correct value.


--
Pl click the YES button
(if you see it - don''''''''t worry if you don''t),
if this answer was helpful.



"Rpt_Me4NotBeingSmart" wrote:

I am using the below formula in D195 to look up an employee's hours.
B195 is Doe, Jane
from the search array, Doe, Jane is in B139 and Doe, Jack is in B138. The
values keep pulling from Jack. Is there a way force it to pull from Jane?

=VLOOKUP(B195,$B$9:$G$190,2)

VLOOKUP and names with Commas
 

:-)

You are welcome... Do , INDEX etc. it will save you hours of effort...

Start at http://www.contextures.com/tiptech.html


"Rpt_Me4NotBeingSmart" wrote:

Thanks. That was very helpful. Oh, and I clicked yes.

"Sheeloo" wrote:

Use False as the fourth parameter...
=VLOOKUP(B195,$B$9:$G$190,2,FALSE)

This is from HELP -
When the fourth parameter is either TRUE or is omitted, an exact or
approximate match is returned. If an exact match is not found, the next
largest value that is less than lookup_value is returned. If range_lookup is
either TRUE or is omitted, the values in the first column of table_array must
be placed in ascending sort order; otherwise, VLOOKUP might not return the
correct value.


--
Pl click the YES button
(if you see it - don''''''''t worry if you don''t),
if this answer was helpful.



"Rpt_Me4NotBeingSmart" wrote:

I am using the below formula in D195 to look up an employee's hours.
B195 is Doe, Jane
from the search array, Doe, Jane is in B139 and Doe, Jack is in B138. The
values keep pulling from Jack. Is there a way force it to pull from Jane?

=VLOOKUP(B195,$B$9:$G$190,2)